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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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