Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Heatmap-like effect in Matrix Visual

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.

  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

     

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

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