Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have a scenario where I have 2 columns in the matrix.Region and class .Program is in row. Count is in value of matrix.
I want to apply gradient coloring ignoring class but within Region.For North region,across all the classes the highest value should be colored in dark red (11) and then the lowest numbers light red. For South Region across all the classes the highest value should be colored in dark red (12) nd then the lowest numbers light red.
How can I ignore the class column in conditional color formatting alone.
Hey @ann33
You can use ISINSCOPE() DAX function in your measure to make calculations at the hierarchy level
and use that measure for conditional formatting.
If it helps please mark my solution as accepted!
and if if you are still facing issue please provide sample data which I can copy and try it on my machine.
Thank you!
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |