Forum Discussion

RAHULBANDI's avatar
RAHULBANDI
Helper II
3 years ago
Solved

***Gauge Chart***

Hi Team,

I have Following Data-set

Hospitals

Abn Group

CCAD

NMC Group

Imperial College

Prime Healthcare

 

I have inserted this Hospitals data in to  slicers

My requirement is when

i select 1 data point in Hospitals it should show 20% in guage chart

if i select 2 data point in Hospitals it should show 40% in guage chart and so one........

Please look into this

Need Help
Show and Tell
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, RAHULBANDI ;

    Try it.

    Measure = DIVIDE( COUNT(Test[Hospitals]),CALCULATE(COUNT(Test[Hospitals]),ALL(Test)))

    Then change the type of this meausre.

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    Hi, RAHULBANDI ;

    Try it.

    Measure = DIVIDE( COUNT(Test[Hospitals]),CALCULATE(COUNT(Test[Hospitals]),ALL(Test)))

    Then change the type of this meausre.

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    RAHULBANDI Try a measure like this:

    Measure = 
    DIVIDE(
        COUNTROWS(SUMMARIZE('Table',[Hospitals])),
        COUNTROWS(SUMMARIZE(ALL('Table'),[Hospitals]))
    )
    • RAHULBANDI's avatar
      RAHULBANDI
      Helper II
      3 years ago

      Hi 

      Thq for your Reply

      I have tried ur measure, but it s showing like this

       

      I'm looking for 20%, 40%, 60% etc;

      and i need the Gauge chart to fill accordingly

      I have taken min = 1, max = 10