Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |