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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
fparker61
Helper I
Helper I

Need help getting a gauge to show the proper percentage

I am trying to get this gauge to work right. The data is shown, basically one row with the data. I want it to show 99.9998% but it either shows 100.00% or .999998% I have expanded the decimals to 5 or 6 and still can't get it to work right. 

 

Thoughts?

 

fparker61_0-1629482164746.pngfparker61_1-1629482205145.png

 

1 ACCEPTED SOLUTION
bchager6
Super User
Super User

Your Target is a text data type and this might be the problem. It's working for me when I make the Score a decimal number and the target a percentage in the query editor (using a 1 for the target in the source data). 

bchager6_1-1629485858042.png

And then in the reporting end I used the following settings:

bchager6_2-1629485929864.png

 

bchager6_3-1629485962921.png

 

 

 

 

bchager6_0-1629485646663.png

View solution in original post

4 REPLIES 4
fparker61
Helper I
Helper I

Sure thing, let me try that. 

bchager6
Super User
Super User

Your Target is a text data type and this might be the problem. It's working for me when I make the Score a decimal number and the target a percentage in the query editor (using a 1 for the target in the source data). 

bchager6_1-1629485858042.png

And then in the reporting end I used the following settings:

bchager6_2-1629485929864.png

 

bchager6_3-1629485962921.png

 

 

 

 

bchager6_0-1629485646663.png

Yeah, that was it. The target was text. Thanks. 

danielwelch
Resolver II
Resolver II

Hi,
@fparker61  your target is formatted as text.

Format them both as percentages and it should show what your after (if im understanding you correctly):

danielwelch_0-1629485941018.pngdanielwelch_1-1629485963285.pngdanielwelch_2-1629485994598.png

All the best,


Daniel.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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