Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a matrix visual and I have set "Show Value as" to "Percent of column total" and then applied Conditional Formatting. It looks nice. But it is wrong. It appears to me that the conditional formatting is using the underlying Count of the field as the driver for the conditional formatting (and not the column percentage values).
>>> How do we get the matrix to display the correct formatting? <<<
Is there a way to do this without creating a measure?
Solved! Go to Solution.
It doesn't look like the percentage versions of the calculation are an option in the conditional formatting settings so you'll need to define a measure that gives the percentage of column total.
Such a measure would look like this:
DIVIDE (
COUNT ( Table1[Value] ),
CALCULATE ( COUNT ( Table1[Value] ), ALL ( Table1[Column1] ) )
)
where [Column1] is whatever you're using for your row headers in the visuals.
It doesn't look like the percentage versions of the calculation are an option in the conditional formatting settings so you'll need to define a measure that gives the percentage of column total.
Such a measure would look like this:
DIVIDE (
COUNT ( Table1[Value] ),
CALCULATE ( COUNT ( Table1[Value] ), ALL ( Table1[Column1] ) )
)
where [Column1] is whatever you're using for your row headers in the visuals.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |