Forum Discussion
How to Set Gauge Target?
Hi, I have made a Gauge showing total sales MTD,QTD,YTD using Measures, now I want to show the target inoin gauge same like MTD, QTD & YTD. Can someone guide me. Thanks in advance
Hi abhishek-93 ,
You could create a slicer table which includes "MTD","QTD","YTD".
Then create a measure to show the value.
Measure =
VAR a = [MTD]
VAR b = [QTD]
VAR c = [YTD]
VAR d =
SELECTEDVALUE ( 'Slicer'[Column] )
RETURN
SWITCH ( d, "MTD", a, "QTD", b, "YTD", c )As to target value, you could also refer to the measure above.
When you select "MTD" in slicer, the gauge will show total sales MTD and its target value.
Hi, v-eachen-msft ,
I am already using date slicer to show the gauge, do you think we should use slicer again?
