Forum Discussion
Date Slicer
Hello,
I was just wondering if it is possible to have a date slicer affect different visuals differently. I have a report that has different metrics on it that all update monthly. Many of the visuals contain data that builds on itself, so they need to be able to show a range of data (ex. January through August), but there are a couple visuals on the same page that need to only show a snapshot of the most recent data. In my example of January through August, the other visuals need to show data just for August instead of all data. Is this something that is possible with a single slicer?
I apologize, as I can't share my .pbix file. Thank you!
2 Replies
- aj1973Community Champion
- SamFischerFrequent Visitor
You'll need to write a measure for the visuals that need to show only the latest month. In your case, you can use the same logic as in this forum post: https://community.powerbi.com/t5/Desktop/Latest-Month-value/m-p/383443/highlight/true#M174525