Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a matrix with country names along the side, and categories across the top. Each of these country - category combinations has a calculated percentage as the value. I've applied the background colour in the cell element, but it's basing the colour of the entire set of columns, and not of that categroy columns subtotal. This causes an issue as for example, 8% in one category is a very good result, while 67% in another category is a bad result. But the 8% shows up as dark red, while the 67% is green. Is there a way for me to base the background colour of the subtotal of each individual column category?
So for example, Column A would have a subtotal of 63%, a value of 44% would be red. Column B would have a subtotal of 7%, a value of 9% would be green. I attached a rough mockup screenshot to show what my intended goal is, vs what i currently have.
Hope this all makes sense, any help would be greatly appreciated.
Solved! Go to Solution.
Hi @OMcP
You need to create a ranking measure based on category, like :
I Made an example for one of my blog posts with other data :
The pbix with the example is attached
You can also take a look at my old blog post about heat map ( there is a row logic there but it is the same, just change the DAX of ranking to the columns level )
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @OMcP
You need to create a ranking measure based on category, like :
I Made an example for one of my blog posts with other data :
The pbix with the example is attached
You can also take a look at my old blog post about heat map ( there is a row logic there but it is the same, just change the DAX of ranking to the columns level )
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Happy to help🌼
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
80 | |
64 | |
52 | |
48 |
User | Count |
---|---|
213 | |
89 | |
77 | |
66 | |
60 |