Forum Discussion
Create pie chart based on measure
Power BI (unlike Tableau) does not support dynamic bucketing. You need to bring your own buckets, in a disconnected table - like you did in the "Notice" table. You can then base your
horriblepie chart on that table.
Power BI (unlike Tableau) does not support dynamic bucketing. You need to bring your own buckets, in a disconnected table - like you did in the "Notice" table. You can then base your horrible pie chart on that table.
Thank you for your reply!
Just one question: Why can't we apply [Sum_Sales Amount] > 0 directly in 'Filters on this visual'?
you need to group first before you can apply the measure filter. Otherwise it would attempt to filter the individual rows.
One more question:
How can I create a pie chart that shows the count for each notice type?
I want the pie chart to show:
- Number of Sales Notices
- Number of Refund Notices
Do I need to create a separate measure for each notice type?
You can change your buckets to represent notice types. (Sales or Refund) Then adjust your measure accordingly
Are you sure a pie chart is the right chart for the data story you are trying to tell?