Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
I want to create a matrix table, but it is more complex than usual. I want to assign colours for each value (and there are only three values: 1, -1 or the cell is empty. The result should be like this:
The value 1 is the colour green, -1 is purple en the empty cell is grey. The Excel-sheet looks like this:
https://docs.google.com/spreadsheets/d/1aI6ikWyc5-k1hnRSS9l061RYfxONcv5S7Q2auKtYO9U/edit?usp=sharing
Could someone help me with this, please?
Solved! Go to Solution.
Hello again @Anonymous ,
Yeah it's not that good the way you see it, I suppose you're using more value variables which will return a pretty ugly matrix is that it?
If you create a measure for each column you won't have that problem.
Let me know if that was it.
Best Regards
Duarte Raminhos
Hi @Anonymous ,
You use the matrix visual assign the rows and columns fields as you usually would.
To show colors instead of numbers I've been formating the values font to white so it's not seen, after that you have to use the "Conditional Formating" and assign each color to each value.
Let me know if it helped,
Best Regards,
Duarte Raminhos 😁
Hi @Anonymous ,
Thanks for your reply. It is a start, but it isn't sufficient.
I made two screenshots. I used only one variable to simplify the example.
I am not satisfied with the visualisation; 'Pedagogisch beleid is shown above and the values (-1 and 1 which have a white font now) are shown in the rows. But it should be like this:
dec-2018 april-2019
Pedagogisch beleid red circle green circle
Hello again @Anonymous ,
Yeah it's not that good the way you see it, I suppose you're using more value variables which will return a pretty ugly matrix is that it?
If you create a measure for each column you won't have that problem.
Let me know if that was it.
Best Regards
Duarte Raminhos
Hi @Anonymous ,
You were right; I unpivot all the columns I needed, so that I retained one column.
I used the following measure for the colour system:
KPI light = IF(
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |