Forum Discussion
Interactive Slicers
Hello Everyone,
I was just wondering, is there any way to make a slicer change it's value automatically, by changing the value on a second slicer.
My case: I want to display three different card visuals, with the following values: Actuals (Previous Year-Month ) - Actuals (Current Year- Month) - Budget ( Current Year-Month). I currently have the Slicer Year-Month allowing users to choose a specific month for the aformentioned values to be displayed. However for Actuals (Previous Year -Month ) I need a seperate slicer choosing the same month that is selected but for the previous Year. F.x if a user chooses 2022-01, Actuals (Current Month Selection) - Budget ( Current Month Selection) will displayed correcty, but they will also need to make a change to the 2nd slicer that is affecting the Actuals (Previous Year) to show 2021-01 . Is there a way where by changing the 1st slicer, the 2nd slicer calculates the value it now needs to display?
Thank you all in advance,
I hope I made my case understandable!
1 Reply
ChrisFloko Slicers are interactive by default but you need to have the proper relationships in place. Would need to understand your data in more detail. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
