Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Heatmap formula help

Hi, am new to PBI and am stuck trying to show a heatmap table of the % of people per level/dept that have a selected attribute.


Any ideas on the formula?



               Grade 1      Grade 2

Dept A      #%                #%

Dept B      #%                #%


eg Formula needs to show the % of people in dept A grade 1 that have the attribute (attribute is in a column).

Community Support
Community Support

hi, @UpdateAvailable 

You may try to use “all” functions in your formula. see this blog:

If not your case, please share Sample data and expected output. Please see this post regarding How to Get Your Question Answered Quickly:

Best Regards,


Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post Patron
Post Patron

Hi @UpdateAvailable ,


For your problem you can create calculated column for two Dept and then pull the calculated column values into heatmap based upon your requirement to the report page. Now you can filter Dept A and grade 1 with the help of

the slicer.


Try this formula for creating calculated columns,


% of Grade 1 = DIVIDE(Sheet1[grade1],Sheet1[grade1]+Sheet1[grade2])
% of Grade 2 = DIVIDE(Sheet1[grade2],Sheet1[grade1]+Sheet1[grade2])


Thanks & regards,


Helpful resources

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors