Forum Discussion

highlander25361's avatar
highlander25361
Regular Visitor
3 years ago
Solved

Pie Chart split slice colours

I have a piechart created from a matrix table whuich has 4 data sources. Each source is broken down into Total users. completed test, rescheduled, excempt and Still to be tested.   What Im trying t...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi highlander25361 

    you can refer to the following example:

    e.g

    Measure = IF(ISFILTERED('Table (4)'[Column1]),IF(MAX('Table (4)'[Column1])="TableA",SUM(TableA[Column2]),SUM(TableB[Column2])),SUM(TableA[Column2])+SUM(TableB[Column2]))

    Output:

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi highlander25361 

you can refer to the following example:

e.g

Measure = IF(ISFILTERED('Table (4)'[Column1]),IF(MAX('Table (4)'[Column1])="TableA",SUM(TableA[Column2]),SUM(TableB[Column2])),SUM(TableA[Column2])+SUM(TableB[Column2]))

Output:

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dangcab's avatar
dangcab
Regular Visitor
2 years ago

Hello, I tried to recreate your suggestion in my project because I have the same situation, but in my case I want to divide by months, and I have multiple columns, I spent a lot of time but I didn't get the result. My only option is to duplicate the main PIE and change the parameters. Do you have another option using Months as a divisor?

 

I appreciate anye help.

 

dangcab