02-15-2018 06:04 AM - edited 02-19-2018 05:57 AM
Here is what I would like to acomplish:
I have two identical graphs. One displays data for Month 1 (January), the other is the exact same, just diplaying data from the following Month (February). I would like to add a slicer, that changes both charts. So if I change chart 1 to use data of another month (lets say June) the second chart will display data of the following month (July).
My attempt to ahieve this:
I have added two slicers, one for each graphs. Manually I now can set the first Visualisation to display month one and the second one to display another month. I would like to make those slicers related, that the second slicers always equals slicer one + one month. Is there any way to achieve this? Any other ideas?
There is the opportunity to use the sliders to display data from this month in Visualisation 1 and data for the next month in Visualisation 2. However I would like to display any two months.
PS: I'm not very experienced with Power BI so please excuse if this is a repetitive question...
02-15-2018 10:51 PM
Another way to look at this:
There is the option to filter relative Dates (Show data within next x months).
Is there a way to make this related to the month chosen in another chart, rather than the current one?
02-19-2018 01:06 AM
02-19-2018 01:38 AM - edited 02-21-2018 04:23 AM
Thank you for your reply @v-chuncz-msft!
I am not sure, this is what I am looking for.
Yes, with measures I can pick a date, modify it and display it in a table.
However, how do I use this date to filter within a Chart?
I don't really care about the date itself, I just wanna filter all entries within that month.