Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Hi @Jansco ,
We can create a measure as below and set conditional formatting based on it.
Measure = IF(MAX(Parameter[Parameter]) > MAX('Table'[value]),"#FF000F",BLANK())
Hi @Jansco ,
We can create a measure as below and set conditional formatting based on it.
Measure = IF(MAX(Parameter[Parameter]) > MAX('Table'[value]),"#FF000F",BLANK())
Yes. I actually do exactly this in my upcoming book, Learn Power BI from Packt publishing. (Sorry, not out until September). The trick is to first use a What If measure. Once you have that, you can create another measure to base your conditional formatting on. Basically use MAX or SELECTEDVALUE to grab the value of your slicer and compare it with the other value you have in the current context. Return something like 1 if higher and 0 if lower. Define your conditional formatting rules on this measure.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |