Heatmap-like effect in Matrix Visual

[MarceloVieira]

Hello Everyone,

I'm trying to apply conditional formatting in Power BI to color the cells based on their values, using a heatmap-like effect (e.g., lower values in red, higher values in green, with a gradient in between).

However, I want the color scale to be applied within each row's context, not based on the global minimum and maximum across all rows. In other words, each row should have its own independent color range instead of a single scale for the entire dataset.

What would be the best approach to achieve this? Should I use a DAX measure, or is there another way to set up the conditional formatting dynamically?

Any help would be appreciated!

pbix sample: https://drive.google.com/file/d/1ePFIngH_qERC_mDt5yKcwmqiEsUaqz_k/view?usp=sharing

Similar effect desirable: 

In the actual dataset, the A, B context has several rows (like a hundred). We will navigate the report page with some filters, but the formating should work properly with or without any filtering.

*There is 2 page filters that are always active across all report pages.

[MarceloVieira · Accepted solution]

Thks @Ashish_Mathur + @Greg_Deckler !!!

I was showing these proposals to the client, and we ended up opting for a manual solution, defining ranges and colors, which is also not perfect but was considered an acceptable solution.

[Ashish_Mathur]

Hi,

Not perfect but can you live with this

[Greg_Deckler]

@MarceloVieira See if this helps. Also, I would create a measure for returning your colors, this will give you full control over context, etc.