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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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 carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.