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.
Hello,
Is it possible to filter 2 charts with the same dataset and different date range?
What i mean? I have 2 slicers: month and year and 2 charts: daily and monthly.
I have something like this:
Is it possible to correct it? Would be nice to show data for specific month on daily chart after clicking on it on monthly chart.
Regards,
Karol
Edit:
When i turned on all interactions i have something like this:
Still cant see all months
Hi @kchojnowski
If you want the 2 chart can filter with each other, you may use 'Edit interactions' as below. Here is the document for your reference.
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Regards,
Cherie
THank you, but i have also tried it. And it doesnt work.
Month filters daily chart - OK
Month doesnt filter monthly chart - OK
Still monthly chart wrongly filters daily chart - WRONG. Is it avaible to filter like that?
Hi @kchojnowski
You may try do the same for the Year slicer as before. If it is not your case, please share the sample file for us to check again. You can upload it to OneDrive or Dropbox and post the link here or send me via private message.
Regards,
Cherie
It doesnt work for me.
I sent link to dropbox on priv.
Karol
Hi @kchojnowski
You may try to edit the daily chart as below. The month slicer filter the Daily chart. And in that month is blank value. So daily is blank too.
Regards,
Cherie
Hi @kchojnowski
Did i answer your question? If so,please consider to mark my answer as solution this will also help others. If not, please explain more about your expected output so that we could help further on it.
Regards,
Cherie
Unlucky, it doesnt work.
Month slicer should filter: only daily chart
Year slicer should filter: daily and monthly chart
So picking July on monthly chart i should get some data on daily chart from this month(july). Should I write more measures or something?
Edit interactions doesnt help
Hi @kchojnowski
I'm afraid that it could not be achieved as your request. 1.Month slicer filter daily chart; 2.Monthly chart filter daily chart. You may only choose one way from those. When you use Month slicer, daily chart will be filtered by it and it cannot be filtered again with the other months in monthly chart. Hope my explain could help you.
Regards,
Cherie
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |