Forum Discussion

abhishek-93's avatar
abhishek-93
New Member
6 years ago

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

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      abhishek-93
      New Member
      6 years ago

      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.

       
  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    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.