Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I am trying to create a gauge with a dynamic maximum, which can only be influenced by a date slicer, I do not want my other Nature Slicer that you will see in my example below to be able to influence the maximum.
I am attaching an example : Here
I tried several formulas but it didn't work.
Someone can help me please ?
Thanks
Solved! Go to Solution.
Hi,
PBI file attached.
Hope this helps.
Hi @Vahks ,
Have you solved your problem?
If not, please try this way.
Use this column to build a new table without any relationships:
Use this DAX to create a measure in the new table I build just now and put it into the Maximun value of the Gauge:
Test1 =
CALCULATE(COUNT('Slicer'[Created_At]), FILTER('Slicer', 'Slicer'[Created_At] >= MIN('Calendar'[Dates]) && 'Slicer'[Created_At] <= MAX('Calendar'[Dates]) ))
The final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Turn Off interactions.
Hi Turn off interactions doesn't work because i don't need to fix the value, only the max value of the gauge when i click on the other filter.
Thanks
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |