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
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
Resolver III
Resolver III

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

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Kudoed Authors