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

ffbibire

 

 

This Image kinda gives a bit of a breakdown. These two Account types on the top are in the same excel sheet but different sheets on PBI Desktop. Beneath that they each have their own account budgets.  Beneath that is budget by year. There are also budgets by quarter but I am not going to go that deep right now.