Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 to do is for each datasource pie slice, have each segment of that slice a different colour, so that if I used a slicer and chose a specific data source, each part of that pie would be a different colour. At the moment, I can see each data source and the splits per matrix column but they are the same base colour
Is this possible out of the box?
Solved! Go to Solution.
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.
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.
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
Hi!
Not out of the box, as far as I know. You can split colors either by category or source, but there will be shared colors.
What you probably could to is to create a new table where all data sources are combined using UNION(). In that table create a new column using CONCATENATE() with Category and Data Source as input and then using that column along with the values in your pie chart. That should give you the opportunity to set distinct colors for all combinations of data source and category.
Good luck!
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |