Forum Discussion
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
and I used the following code
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.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
9 Replies
change the chart type to stacked bar chart.
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.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. For more information, please refer to: Visual Awesomeness Unlocked: Tachometer Gauge Custom Visual
Best Regards,
Winniz
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
