Power BI doesn't show value

[Alex069]

Hello Everyone,

I'm trying to create an interactive dashboard with Security/Medical Risk location, it's working fine until I try to add a "Risk Gauge".

The risks are from Low (1) until Extreme (5)

As per the example on the left.

Until now the Dash is working OK, the shows what it needs to show and things like that.Until now the Dash is working OK, the shows what it needs to show and things like that.

But The gauge is not showing correctly 

 is should show 4, and not 2, 

The only options that I have are below:

I want to show the raw value of each contry when I click it, like it should have shown "4" for High Risk

Tried everything and can't find a solution....

[vigneshba]

@Alex069  - Yes @shafiz_p  is right

[shafiz_p]

@Alex069When you are not filtering or selecting any country it will show the median of all country, which is 2. after selecting a country it will show the corresponding medical risk, Since there is only one row per country, as per your table, regards less of any measurement.  For my case, it is showing 4 for Georgia.

Min = 1, Max = 5, Median = Median(Table[Medical Risk]).

Hope it helps!! If I answered your question, please mark it as a solution.