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
biloser
Regular Visitor

How to determine Min and Max Value as percentage for Dial Gauge

Hello,

I downloaded the dialGauge visualization and I would like to use it, but I don’t know how to determine the min, max and target value correctly.

I want to determine Percentage Values for it like that:

Min Value =  0%

Max Value= 100%

Target Value= more than 50%

The problem is I cant determine it by hand, I can only choose datas like columns for following categories: Min, Max,Target start,Target end, Actual start, Actual end,Pointer Value, Percentage, Chart Name. 

Can someone help me how I can determine the percentage values?

Thank you very much in advance!

Best Regards

1 ACCEPTED SOLUTION
Phil_Seamark
Employee
Employee

Hi @biloser

 

If you want to just hard-code your values?

 

If so, you can just create calculated measures like

 

Max = 1

and 

Min= 0

You can format these as percent and drag to the appropriate fields on the visual.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
JanSchuppius
Frequent Visitor

I am having the exact same problem. Everything is formatted as percentages, but the visual still displays decimal values. Any ideas?

Phil_Seamark
Employee
Employee

Hi @biloser

 

If you want to just hard-code your values?

 

If so, you can just create calculated measures like

 

Max = 1

and 

Min= 0

You can format these as percent and drag to the appropriate fields on the visual.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

I'm having this same problem. I created all the measures and defined their format as "Percentage", but the visual still shows the raw data, without the % format. Any ideas?

 

2023-05-10 15_07_33-GRC Dashboard - App View - Power BI Desktop.png

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.