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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote 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
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 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.