Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I do have a question about conditional formatting and maybe one of you has a solution for it.
In my dashboard there is a matrix and I want to format/color the fields of CPM TL to CPM BVB based on the countries.
There is a relationship between countries of both fields to a country table which is shown as the first column.
If CPM TL is smaller than CPM BVB I want it to be red and if it is greater it should be green. So far I only managed to do a formatting according to the average of CPM BVB or within CPM TL (min or max).
Does anyone of you have an elegant solution on how to solve this problem?
Please lt me know if you have any additional questions and thanks in advance.
Solved! Go to Solution.
hello
I think it should help you
Color measure= if ([CPM TL]>[CPM BVB],"green","red")
you should apply it measure to Conditional formating->Background color->
Format Style - Field Value
What field on should base this on? - [color measure]
ok
Thank you, that did the trick!
hello
I think it should help you
Color measure= if ([CPM TL]>[CPM BVB],"green","red")
you should apply it measure to Conditional formating->Background color->
Format Style - Field Value
What field on should base this on? - [color measure]
ok
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |