***Gauge Chart***

[RAHULBANDI]

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

[v-yalanwu-msft · Accepted solution]

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]

@RAHULBANDI Try a measure like this:

Measure = 
    DIVIDE(
        COUNTROWS(SUMMARIZE('Table',[Hospitals])),
        COUNTROWS(SUMMARIZE(ALL('Table'),[Hospitals]))
    )

[RAHULBANDI]

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