Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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
Thank you, that was quick and simple.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |