Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dynamic Gauge using Slicers

Please excuse me if this topic has been covered before but the posts that I found did not help me towards my goal. I am fairly new to Power BI and I am trying to set up a gauge for a budget spreadshe...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    Please look into my test, is this what you want?

    dataset:

    create measures:

    min_value = 0

max_value = CALCULATE(SUM(Sheet2[values]),ALL(Sheet2))

    171 is the total values of the table.

     

    If you have any problem, please let me know.

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous

As tested with this dataset, 

date            account  value      max

1/1/2016 a 1 2
1/1/2016 b 2 3
1/1/2017 a 3 4
1/1/2017 b 4 5

 

when i add "date" and "account" in differnt slicer, selecting items from slicer could reflect the gauge.

 

 

Best Regards

Maggie