Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |