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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.