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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
eggwald
Frequent Visitor

Dynamic Value Not Filtering correctly

Hello, 

 

I have a summary sheet on a report that I want to use to grab various bits of information, like so: 

eggwald_0-1668793795900.png

The issue I am having is that the Dynamic Values take the customer into account (I change the customer and the values change), but they do not take the date into consideration.

 

For example the 98.2% shown is just showing the SLA met for All tickets raised by that customer, it should be showing at 97.3% which is what the % should be for the last 3months.  Page 2 of the report shows the correct data

eggwald_1-1668793995938.png

Both the dynamic value and the tile reference the same Measure

 

Any help appreciated. 

 

Cheers

Ed

1 ACCEPTED SOLUTION
eggwald
Frequent Visitor

I found the issue. User error! I hadn't put the filter on the page. Added the filter and it worked perfectly.

View solution in original post

2 REPLIES 2
eggwald
Frequent Visitor

I found the issue. User error! I hadn't put the filter on the page. Added the filter and it worked perfectly.

daXtreme
Solution Sage
Solution Sage

To be able to troubleshoot one needs data to work with. Please give a link to a representative example of your issue. You can place such a file on a shared drive and grant correct access rights so a public user can open the file. Thanks.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors