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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Rotemshan
Helper I
Helper I

Create a gauge

I'm trying to build a Gauge,

I managed to divide the data per the requested 

The gauge shows rank divided as followed:

0-6 - Red

7-8 - Amber

9-10 - Green

 

I managed to create the following graph 

Rotemshan_0-1648112817419.png

 

and I used the following code 

Response_table APAC =
SUMMARIZE (
Merge1,
Merge1[Response_Details.Likely to Recommend NPS.1],
"0-6", CALCULATE (
COUNT (Merge1[Response_Details.Likely to Recommend NPS.1] ),
 
Merge1[Response_Details.Likely to Recommend NPS.1] >= 0
&& Merge1[Response_Details.Likely to Recommend NPS.1] <= 6
&& Merge1[Account Region]="APAC"
)
,
"7-8", CALCULATE (
COUNT ( Merge1[Response_Details.Likely to Recommend NPS.1] ),
 
Merge1[Response_Details.Likely to Recommend NPS.1] > 6
&& Merge1[Response_Details.Likely to Recommend NPS.1] <= 8
&& Merge1[Account Region]="APAC"
)
,
"9-10", CALCULATE (
COUNT ( Merge1[Response_Details.Likely to Recommend NPS.1] ),
 
Merge1[Response_Details.Likely to Recommend NPS.1] > 8
&& Merge1[Response_Details.Likely to Recommend NPS.1] <= 10
&& Merge1[Account Region]="APAC"
)
,
"0-10", CALCULATE (
COUNT ( Merge1[Response_Details.Likely to Recommend NPS.1] ),
 
Merge1[Response_Details.Likely to Recommend NPS.1] >= 0
&& Merge1[Response_Details.Likely to Recommend NPS.1] <= 10
&& Merge1[Account Region]="APAC"
)
)
 
I would like to present the same on a gauge but couldn't understand how to do that
I wish your assistance
2 ACCEPTED SOLUTIONS
v-kkf-msft
Community Support
Community Support

Hi @Rotemshan ,

 

Please try the Tachometer visual and create the measures:

 

Range2Start_0-6 = MAX ( 'Response_table APAC'[0-6] )
Range3Start_0-8 = [Range2Start_0-6] + MAX ( 'Response_table APAC'[7-8] )
TotalValue_0-10 = MAX ( 'Response_table APAC'[0-10] )

vkkfmsft_1-1648437514692.png

vkkfmsft_2-1648437526993.png

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

View solution in original post

Hi @Rotemshan ,

 

Please try the following measures:

 

Range2Start_0-6 = SUM ( 'Response_table APAC'[0-6] )
Range3Start_0-8 = [Range2Start_0-6] + SUM ( 'Response_table APAC'[7-8] )
TotalValue_0-10 = [Range3Start_0-8] + SUM ( 'Response_table APAC'[9-10] )

vkkfmsft_0-1648807470176.png

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz

View solution in original post

9 REPLIES 9
Anonymous
Not applicable

Hi, 

Another option is to create a Gauge that dynamically changes colour based on the current value. 

biancagilly_0-1661490064506.png

For video demonstration, click the link: https://youtu.be/oEL36Fp3TU0

v-kkf-msft
Community Support
Community Support

Hi @Rotemshan ,

 

Please try the Tachometer visual and create the measures:

 

Range2Start_0-6 = MAX ( 'Response_table APAC'[0-6] )
Range3Start_0-8 = [Range2Start_0-6] + MAX ( 'Response_table APAC'[7-8] )
TotalValue_0-10 = MAX ( 'Response_table APAC'[0-10] )

vkkfmsft_1-1648437514692.png

vkkfmsft_2-1648437526993.png

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

Thank you for the detailed answer, 

I would like to ask a few questions:

Why did you subtract the range of 0-8 instead of counting only 7-8? and the same for 0-10 instead of 9-10?

There is a calculation that should be done on the Is it possible to put the needle on 15?

 

 

Range2Start_0-6 = MAX ( 'Response_table APAC'[0-6] )
Range3Start_0-8 = [Range2Start_0-6] + MAX ( 'Response_table APAC'[7-8] )
TotalValue_0-10 = MAX ( 'Response_table APAC'[0-10] )

 

Hi @Rotemshan ,

 

The Tachometer visual does not automatically accumulate the values of each range, so we need to specify the starting value of each range. The descripyion of these labels are as follows.

 

FIELD

DESCRIPTION CONSTRAINTS
End Value The End Value for the Tachometer Arc If “Start Value” is the minimum value in the value range, then “End Value” should be the maximum value in the value range or vice versa. All values defined by other Data Roles should lie between Start Value and End Value.
Target Value The Target value that will be displayed by the target line. Value should be between “Start Value” and “End Value” to be to be displayed on the gauge.
Note.Tachometer visual will attempt to position the label indicating target value such that it does not overlap any Axis Labels or Callout values. However, target value label may not be rendered in case Tachometer is unable to relocate target label in the visinity of target line.
Range 2 Start Value This is the starting value for “Range 2”. This is also the End value for Range 1. Value should be between “Start Value” and “End Value” to be to be displayed on the gauge.In addition, this value should be between “Start Value” and “Range 3 Start Value” when “Range 3 Start Value” is available.
Range 3 Start Value This is the starting value for “Range 3”. This is also the End value for Range 2 when “Range 2 Start Value” is defined. When “Range 2 Start Value” is not provided, this will also be the End Value for Range 1. Value should be between “Start Value” and “End Value” to be to be displayed on the gauge. In addition, this value should be between “Range 2 Start Value” and “End Value” when “Range 2 Start Value” is available.

 

vkkfmsft_0-1648608434236.png

 

For more information, please refer to: Visual Awesomeness Unlocked: Tachometer Gauge Custom Visual 

 

Best Regards,
Winniz

 

Hi @v-kkf-msft 

I did exactly as you suggested, but, for some reason the counting is incorrect 

 

Rotemshan_0-1648619593245.pngRotemshan_1-1648619968783.png

Rotemshan_2-1648620052906.png

 

Hi @Rotemshan ,

 

In my data, [0-6], [7-8], [9-10], [0-10] are the columns in the table (and each row is duplicate value), so I calculated the maximum value of these columns. 

 

vkkfmsft_1-1648622486258.png

vkkfmsft_3-1648622909304.png

 

How are your Detractor, Passive and Promoter calculated? Are they from three separate columns or one measure?

 

vkkfmsft_0-1648622387303.png

 

Best Regards,
Winniz

Hello @v-kkf-msft 

as I presented in the first post, 

I created a new table and I'm using the following formula (I'm not sure this is the recommended way to do it )

then I'm getting the following as fields available for me 

Rotemshan_0-1648788824084.png

which creates the following table 

Rotemshan_1-1648789612894.png

 

 

 

Response_table APAC =
SUMMARIZE (
Merge1,
Merge1[Response_Details.Likely to Recommend NPS.1],
"0-6"CALCULATE (
COUNT (Merge1[Response_Details.Likely to Recommend NPS.1] ),
 
Merge1[Response_Details.Likely to Recommend NPS.1] >= 0
&& Merge1[Response_Details.Likely to Recommend NPS.1] <= 6
&& Merge1[Account Region]="APAC"
)
,
"7-8"CALCULATE (
COUNT ( Merge1[Response_Details.Likely to Recommend NPS.1] ),
 
Merge1[Response_Details.Likely to Recommend NPS.1] > 6
&& Merge1[Response_Details.Likely to Recommend NPS.1] <= 8
&& Merge1[Account Region]="APAC"
)
,
"9-10"CALCULATE (
COUNT ( Merge1[Response_Details.Likely to Recommend NPS.1] ),
 
Merge1[Response_Details.Likely to Recommend NPS.1] > 8
&& Merge1[Response_Details.Likely to Recommend NPS.1] <= 10
&& Merge1[Account Region]="APAC"
)
,
"0-10"CALCULATE (
COUNT ( Merge1[Response_Details.Likely to Recommend NPS.1] ),
 
Merge1[Response_Details.Likely to Recommend NPS.1] >= 0
&& Merge1[Response_Details.Likely to Recommend NPS.1] <= 10
&& Merge1[Account Region]="APAC"
)
)

Hi @Rotemshan ,

 

Please try the following measures:

 

Range2Start_0-6 = SUM ( 'Response_table APAC'[0-6] )
Range3Start_0-8 = [Range2Start_0-6] + SUM ( 'Response_table APAC'[7-8] )
TotalValue_0-10 = [Range3Start_0-8] + SUM ( 'Response_table APAC'[9-10] )

vkkfmsft_0-1648807470176.png

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz

lbendlin
Super User
Super User

change the chart type to stacked bar chart.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.