Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Vahks
Helper I
Helper I

Dynamic Max Jauge with slicer date

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

1 ACCEPTED SOLUTION

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1707175767144.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
v-junyant-msft
Community Support
Community Support

Hi @Vahks ,

Have you solved your problem?
If not, please try this way.
Use this column to build a new table without any relationships:

vjunyantmsft_0-1708411924884.png

vjunyantmsft_1-1708411954370.png

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:

vjunyantmsft_2-1708412103851.png
vjunyantmsft_3-1708412114814.png

vjunyantmsft_4-1708412136062.png

 

 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.

Ashish_Mathur
Super User
Super User

Hi,

Turn Off interactions.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1707175767144.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.