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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Here is the template for the Report I am creating. I have the budgets on a separate sheet in a completely different format than what can be used. I Suppose my question turns into how may I format this. There is a visual level filter on each budget group. I just need to make the budget a target OR the max value on the gauge. I hope all of this makes sense and you can help me. P.S don't mind the color scheme, that is a work in progress.

v-juanli-msft's avatar
v-juanli-msft
Community Support
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