Need Help with Risk HeatMap

[sondew]

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.

Thanks,
Sonia

[Sunil_Mathew]

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.






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

[sondew]

This is already set, still not working

[Anonymous]

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.

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

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.

[sondew]

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]

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

[sondew · 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?

[sondew]

This worked great, thank you so much

[sondew]

Can you please explain your reply?