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

since you have data in teo different tables, if it doesn't support creating any relationship between them, 

and they have the same columns, for example:

table1:

account | date | value | budget

table2:

account | date | value | budget

 

Please open Editor Queries, append two tables. 

 

 

Best Regards
Maggie

 

“
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
“

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I created a sample data set that shows the amount of layers involved. In  the default screen it would be nice if the gauge didnt show anything, and it only activates when you select slicers. I am not sure how to accomplish my goal of having the Gauge change based on budget. I am unfamiliar with how to use relationships. Please excuse my noobiness. In the actual dataset there are around 20,000 lines of data