Forum Discussion
Sum backup status
Hi, I'm brand spanking new in Power BI.
I'm trying to produce a dashboard with a summary of backups that have completed.
I need a pie chart to give a total number of completed backup.
My backup status can be in 'Completed' 'Failed' or 'Completed with warnings'.
Each status should consume the piece of the pie.
I would greatly appreciate your assistance.
Hello Mzwai99 ,
In Power BI, you can select Pie Chart visualization then, put the status column into legend and put the numerical value that total number into values. Below the image as shown as a example.
Kind Regards,
Gรถkberk Uzuntaล
๐ If this post helps, then please consider Accepting it as a solution and giving Kudos โ it helps other members find answers faster!
๐ Stay Connected:
๐ Medium |
๐บ YouTube |
๐ผ LinkedIn |
๐ท Instagram |
๐ฆ X |
๐ฝ Reddit |
๐ Website |
๐ต TikTok |Thanks for the reply from danextian and uzuntasgokberk, please allow me to provide another insight.
Hi Mzwai99 ,I'm not sure how your dataset is designed, here is my sample.
The data table is shown below.
Create a pie chart.
- Drag the Backup Status column to the Legend field well.
- Drag the Backup Status column again to the Values field well. Power BI will automatically count the occurrences of each status.
Please see the attached pbix for reference.
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Mzwai99
This what I can suggest based on the information provided:
Ensure your data is properly prepared, with a column categorizing each backup by its status. Use this column for the pie chart's segments/legends, to the value tile add a column and aggregate this as count assuming that each record in the data is equivalent a comleted backup.
Otherwise, please refer to this post on how you can get better answers.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hello Mzwai99 ,
In Power BI, you can select Pie Chart visualization then, put the status column into legend and put the numerical value that total number into values. Below the image as shown as a example.
Kind Regards,
Gรถkberk Uzuntaล
๐ If this post helps, then please consider Accepting it as a solution and giving Kudos โ it helps other members find answers faster!
๐ Stay Connected:
๐ Medium |
๐บ YouTube |
๐ผ LinkedIn |
๐ท Instagram |
๐ฆ X |
๐ฝ Reddit |
๐ Website |
๐ต TikTok |Thanks for the reply from danextian and uzuntasgokberk, please allow me to provide another insight.
Hi Mzwai99 ,I'm not sure how your dataset is designed, here is my sample.
The data table is shown below.
Create a pie chart.
- Drag the Backup Status column to the Legend field well.
- Drag the Backup Status column again to the Values field well. Power BI will automatically count the occurrences of each status.
Please see the attached pbix for reference.
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
