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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Alex069
Regular Visitor

Power BI doesn't show value

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".

 

1.jpgThe 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.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 

 

3.jpg is should show 4, and not 2, 

 

 

 

 

 

 

 

 

The only options that I have are below:

4.jpg

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....

 

 

 

2 REPLIES 2
vigneshba
Frequent Visitor

@Alex069  - Yes @shafiz_p  is right

shafiz_p
Solution Sage
Solution Sage

@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]).

shafiz_p_0-1720111735027.png

 

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors