Assistance Required: Heatmap in Matrix Visual for Hierarchical Levels

[suriyachetty]

I have a matrix visual in Power BI with a hierarchical structure consisting of Region and State levels. I’ve applied a heatmap using conditional formatting, which displays correctly at the Region level.

However, when I expand the hierarchy to show the State level, the heatmap is applied only to the State level, and the formatting disappears for the Region level.

I would like the heatmap to remain visible for both Region and State levels simultaneously, even when the hierarchy is expanded.

Could you please guide me on how to achieve this behavior? Kindly help me get this implemented.

Thank you in advance for your support.

[v-venuppu]

Hi @suriyachetty ,

I hope this information is helpful.If this answers your question, please accept it as a solution,so other community members with similar problems can find a solution faster.

Thank you.

[v-venuppu]

Hi @suriyachetty ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-venuppu]

Hi @suriyachetty ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @DataNinja777 for the prompt response.

I want to check whether if you had a chance to review the information provided and resolve the issue..?

If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[DataNinja777 · Accepted solution]

Hi @suriyachetty ,

To have the heatmap apply to both Region and State levels, you need to adjust a single setting. Begin by clicking on your matrix visual to select it. Next, look at the Visualizations pane and find the measure field you are using in the Values bucket. Right-click on this field, and from the context menu that appears, navigate to Conditional formatting and select the type you are using, such as Background color. In the settings window that opens, you will see a dropdown menu labeled "Apply to". Simply change the selection here from the default "Values only" to Values and totals. Once you click OK to confirm this change, the matrix will correctly display the heatmap coloring on both the aggregated Region rows and the individual State rows, even when the hierarchy is fully expanded.

Best regards,