DEV Community

Punitha
Punitha

Posted on

Multi Cards, Gauge and Table

Step 1: Import Data

  • Open Power BI Desktop

  • Click Get Data

  • Select your Excel/CSV file

  • Click Load

Step 2: Card Visual

  • Select Card Visual

  • Drag Job Title -> Value

  • Drag Salary Year -> Value -> Average

  • Drag Salary Hour -> Value -> Average

  • Rename the titles

Step 3: Gauge Chart

  • Select Gauge Chart

  • Drag Salary Year -> Value -> Sum

  • Drag Salary Year -> Minimum Value -> Min

  • Drag Salary Year -> Maximum Value -> Max

  • Drag Salary Year -> Target Value -> Median

  • Rename the title

Step 4: Table Chart

  • Select Table Chart

  • Drag Job Title Short -> Columns

  • Drag Salary Year -> Columns -> Average

  • Drag Salary Hour -> Columns -> Average

  • Go to format visual -> Cell elements -> On the Data Bars

Top comments (0)