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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
raymondxie
Helper II
Helper II

How to create a percentage based on a column

I just started learning PowerBI, here is a spreadsheet I am working on:

ID column1

1   Validated

2   Not Validated

3   Validated

4......

 

I need to create a dashboard with a pie/donut/ring showing the percentage of Validated vs. Not Validated, and two grids beneath the chart.

 

It would be greatly appreciated if someone can tell me the detailed steps.

 

Thank you in advance.

 

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@raymondxie

 

1. Load the data to Power BI  ---Get Data

2. Select PieChart Visual or another (Donut, Bar, Column)

3.  Put Column1 in Legend and Column1 in Values

4. Select Column1 in values and go to Quick Calc

5. In Show Values as : Select Percent of grand total--OK

6.  In Format Tab go to Data Labels --Label Style - Data Value or Both

 




Lima - Peru

View solution in original post

2 REPLIES 2
Vvelarde
Community Champion
Community Champion

@raymondxie

 

1. Load the data to Power BI  ---Get Data

2. Select PieChart Visual or another (Donut, Bar, Column)

3.  Put Column1 in Legend and Column1 in Values

4. Select Column1 in values and go to Quick Calc

5. In Show Values as : Select Percent of grand total--OK

6.  In Format Tab go to Data Labels --Label Style - Data Value or Both

 




Lima - Peru

Thank you, that was quick and simple.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.