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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

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

Jan NL Carousel

Fabric Community Update - January 2025

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