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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.