Create a gauge

[Rotemshan]

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 

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

[v-kkf-msft · Accepted solution]

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] )

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.

[Anonymous]

Hi, 

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

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

[v-kkf-msft · Accepted solution]

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] )

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.

[Rotemshan]

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] )

[v-kkf-msft]

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.

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

Best Regards,
Winniz

[Rotemshan]

Hi @v-kkf-msft 

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

[v-kkf-msft]

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. 

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

Best Regards,
Winniz

[Rotemshan]

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 

which creates the following table 

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"

)

)

[v-kkf-msft · Accepted solution]

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] )

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]

change the chart type to stacked bar chart.