Forum Discussion
Use Measure as Target in Radial Gauge Chart
Hi,
I am using a radial gauge chart to display the progression of the current weeks' alert counts towards the average count over a set time period.
This average count was calculated as a measure; I would like to use this measures' value as the charts' target, but from tutorials I've seen online, they're using columns with summation set to average, which won't work for our purposes.
I've confirmed that the measure outputs the correct value, using a card, so I don't think it's the formula that's the issue. Could it be that radial charts just disallows the use of measures as targets? If so, is there a commonly used work around?
Thank you
Hi Anonymous ,
It's because the target value 656.05 is bigger than the max value of the Gauge chart 458.
In the visualization formatting pane>Visual>Gauge axis, you can change the max value of the chart.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
v-yanjiang-msftCommunity Support
Hi Anonymous ,
By my test, measure can be used in the Target value in the Gauge chart.
If it didn't work for you, please try to change the Gauge chart to a table visual to see if the measure can dispaly correctly.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yanjiang-msft , thank you for the response.
Based on your demonstrated case, I now know that measures can be used as a target.
When creating a short table with the measures used in the gauge chart, the expected results occur: Both values are what I'd expect them to be.
However, when using these same measures in a gauge chart, the target just...nothing.
Could it perhaps be that its the dax formulae used for the target that somehows...works for the table visual, but not the gauge chart?
- v-yanjiang-msft
Hi Anonymous ,
It's because the target value 656.05 is bigger than the max value of the Gauge chart 458.
In the visualization formatting pane>Visual>Gauge axis, you can change the max value of the chart.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.