Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
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...
Here is an example for your reference.
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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |