Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
swathrddy
Helper I
Helper I

Help with Data Prep and Dashboard for KPI

Hi All,

 

I am working on high level KPI and the board wants me to create a dashboard with kPI and targets. request to help me with data prep.

 

I would like to show the following charts:

Exec Page: Gauge chart  with current month target and actual

Summary page: Actual Vs target for each KPI with next due date.

 

Here is the sample data that they collect in a spreadsheet:

swathrddy_0-1721554501640.png

 

Created in Excel:

swathrddy_1-1721554639628.png

Please share any KPI data/PBI File that might be useful.

 

Kind Regards,

Swathi 

 

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Hi @swathrddy - Below resources, you can access and create Power BI files that will help you build your KPI dashboard.

Reference files:

Get samples for Power BI - Power BI | Microsoft Learn

powerbi-desktop-samples/new-power-bi-service-samples at main · microsoft/powerbi-desktop-samples · G...

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
rajendraongole1
Super User
Super User

Hi @swathrddy - Below resources, you can access and create Power BI files that will help you build your KPI dashboard.

Reference files:

Get samples for Power BI - Power BI | Microsoft Learn

powerbi-desktop-samples/new-power-bi-service-samples at main · microsoft/powerbi-desktop-samples · G...

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors