Question

How can I create a Power BI heatmap that dynamically adjusts based on filters?
I want to design a heatmap in Power BI that updates dynamically based on user-selected filters such as date range, category, or region. The visual should reflect changes in data intensity or distribution through color gradients. What is the best approach to build this using conditional formatting, DAX measures, and proper visual setup?

Answer 1

Filters can dynamically affect the Power BI heatmap through both the Matrix or the Table visual, one that uses conditional formatting and DAX measures to relay the data intensity according to filter selections on dates, categories, or regions.

Best Approach

Pick Matrix or Table Visual

Use a matrix for data representation in a grid fashion (for example, regions go into rows and products into columns).

Add your value measure (e.g., Sales, Count) to Values.

Develop DAX Measure for Dynamic Calculation

Define a measure that responds to slicers/filters:

Total Sales = SUM(Sales[Amount])

Applying Conditional Formatting

Select your Matrix → Go to Values > Conditional Formatting > Background color.

Choose a Color scale, then assign a gradient (e.g., light to dark blue).

Power BI automatically adapts the scale based on filtered data unless you fix min/max.

Set All Slicers and Filters

Add slicers for Date, Category, Region, etc.

The Matrix and formatting will update based on user selections.