Guage being dynamic based on slicers

[Anonymous]

Hope everyone is doing well.

I need help with my guages changing based on the slicer I select.

For example, my guage has a max value of $100 for overall but I want the guage to dynamically change the max value to $20 when I select the Renewal slicer, $40 when I select the New slicer, and $40 when I select the Growth slicer.

Can this be done? Any help would be sincerely appreciated. 

[jthomson]

I think you can put measures into a visual like this, you might need to make a quick table with renewal/new/growth and 20/40/40 as the values and add a relationship to your existing data, then sum that 20/40/40 column and use that as your measure. Should be possible.

[Anonymous]

I created a new table:

Type       Value

New         20

Growth    40

Renewal  40

Total       100

I then tried to link the relationship to my orginal table which also has Type and Value; however, when I added the new table to the visual, nothing changes.

I must be doing something wrong. 

[v-lionel-msft]

Hi @Anonymous ,

Like this? I don’t particularly understand what you want to achieve.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.