How to Set Gauge Target?

[abhishek-93]

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

[v-eachen-msft]

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.

[abhishek-93]

Hi, @v-eachen-msft ,

I am already using date slicer to show the gauge, do you think we should use slicer again?

[Anonymous]

Hi, 

Can you please clarify what your target is and maybe provide some sample data and a sample of what your want your output to look like?

The guage visual only accepts one value, so are you wanting 3 guages one for YTD, QTD, MTD?

Thanks,

Kim 

[abhishek-93]

Hi Kimberly_MT,

I have made 3 different Gauge showing  MTD, QTD & YTD of total unit sold.

now I want to set the target likewise MTD QTD & YTD so that when I select the date It shows me the unit sold and the target of that year.