Forum Discussion
PIE Chart - Counting Values
Hi Gasdetect40
If you go to canvas view in Power BI Desktop, select a Pie Chart. Drag the Event Description column into the Legend space and then drag the Event Description into the Value space. Make sure to click the down arrow on the Event Description in the Values section and click Count.
Hope this helps.
Theo 🙂
Hi Gasdetect40 ,
Agree with TheoC to simply use the summarize type of "Count" for Event type:
Or you could create a measure to calculate the count of each description:
Measure = CALCULATE( COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Event description]))Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi TheoC ,
Of course! as you mentioned, COUNTROWS ( 'Table' ) is enough for this simple case. I'm just used to “fullfill” the measure in case there are some more complex situations. Sorry for the redundant operation😜
Best Regards,
Eyelyn QinHi @Gasdetect40
If you go to canvas view in Power BI Desktop, select a Pie Chart. Drag the Event Description column into the Legend space and then drag the Event Description into the Value space. Make sure to click the down arrow on the Event Description in the Values section and click Count.
Hope this helps.
Theo 🙂
Thanks yes I was worried about how it would affect other columns in the table, so I created a copy and then practiced on that.
Can you Pivot/Unpivot on selected columns within a large table?
Whibley92 yeah, absolutely you can do it. But, as you mentioned, for large tables with many columns it can lead to data redundancy and duplication. For example, if you created a measure such as COUNTROWS before the Pivot / Unpivot in Power Query, you will likely find that it will be a different result to that after the Pivot / Unpivot. This is the same with other aggregation fucnctions such as SUM.
One way to ensure you don't run into these issues is by structuring your model appropriately. So, for example, if you are working on a large table that has a range of categorical data (imagine an Employee Master File in a single table, for example), there are columns associated with 1) Address, 2) Bank Accounts, 3) Personal attributes, etc. For each category, you could create a table that has the Employee Id, Address Line 1, Address Line 2, Suburb / Region, State, Country, Postcode. Similarly, with teh Bank Account details you could have the Employee Id, Bank Account Name, BSB Number, Bank Account Number, SWIFT, etc.
Hopefully the above provides some additional context!
Cheers mate.
Theo
- Hii, Can you help me with the pie chart or donut, as in my pie have only 6 category which im showing as data value and percentage of total and even tried with showing label separately and only % over the slices. The problem with pie and donut is when im filtering my report with anything it is getting blank or showing half of the work or Information as in the ss , like when i made with 0 padidng and all all info of visual showing properly but when i trying fitering more than 2 time its getting blank showing only pie chart with those slices colors
Khushboobarai this is likely because of the Visual settings you have applied. I recommend you "reset" the Visual settings and then try again to format it how you would like. Hope this helps.
