Forum Discussion
Pie chart visual DAX options
Hello PowerBI Community! I created a pie chart that was filtered and it represents certain amount of countries that are operated. I would like to show on the same chart non-operated ones by subtr...
Hi,
If you want to show the count of various statuses in one Pie Chart :
1- You could create two separate fields in power query or Power Bi and put those with 0 and 1 values (OperatedValue and Non-Operated Value), then use these fields in one par chart (Count Value) :
2- Create separate measures for Operated and Non-Operated and then use these measures in your Pie chart :
Count of NonOperated =
CALCULATE(
DISTINCTCOUNT('Sheet40'[CountryName]),
'Sheet40'[Status] = "Non-Operated"
)
do it for Operated as well