Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 subtracting Total number of countries by the operated ones that I got by filtering in the same pie chart. How can I do that?

 

Thanks in advance

Need Help

3 Replies

  • MahyarTF's avatar
    MahyarTF
    Memorable Member
    4 years ago

    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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    MahyarTF  Thank you for explaining this. I still have to clean my data and form these two tables. So these are two different options on how to do this? I am still new to PowerBI, and haven't used DAX yet, so maybe the first one would be easier.