Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sondew
New Member

Need Help with Risk HeatMap

I am working on Risk HeatMap, the values on X-axis and Y-axis are Whole Numbers(I have checked multiple times). Verey time I drag and drop them under axis, they get converted to Count and there is no way I can get rid of Count function. 

I appreciate your help.

sondew_0-1716242042018.png

Thanks,
Sonia

 

1 ACCEPTED SOLUTION

I created two measures - test1 = sum('Heat Map - Risk Matrix'[IMPACT]) and test2 = sum('Heat Map - Risk Matrix'[Likelihood]).

Used those in the heat map but still didn't get the right results. What am I doing wrong?

View solution in original post

8 REPLIES 8
Sunil_Mathew
Regular Visitor

Hi @sondew Even though the data type is Whole Number the summarization symbol wont appear near the field name in some cases. You can change this behavior from the column tools. 
Click on any field -> the Column tools will appear on the ribbon. From there change the default summarization. This you have to do only once.

Summarization.png




Follow my YT channel for Power BI Tutorials -> Driven BI Data - YouTube

This is already set, still not working

v-yilong-msft
Community Support
Community Support

Hi @sondew ,

In Power BI Desktop, displaying Count in Visual is the default, and it automatically displays Count of when the Data type is Whole number or Decimal number.

As hackcrr said, you can use Measure to fix this, or I think you can just change Count of to Sum of.

vyilongmsft_0-1716255364251.png

When you change it to Sum of, you can rename it to get rid of it being Count of all the time.

vyilongmsft_1-1716255442537.png

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Yilong, I didn't get this - 'When you change it to Sum of, you can rename it to get rid of it being Count of all the time.'. Can you please explain?

hackcrr
Solution Sage
Solution Sage

Hi, @sondew 

In Power BI, there is an issue with values on the X and Y axes being automatically converted to counts (Count) due to default behavior during data import or field setup. If you want to control aggregation, it is recommended that you use metric values. For example:

Measure = SUM('table'[IMPACT])

 

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly

I created two measures - test1 = sum('Heat Map - Risk Matrix'[IMPACT]) and test2 = sum('Heat Map - Risk Matrix'[Likelihood]).

Used those in the heat map but still didn't get the right results. What am I doing wrong?

This worked great, thank you so much

Can you please explain your reply?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors