Cant filter 2 charts - daily and monthly

[kchojnowski]

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:

• When i click on data on Daily chart, is ok, it filters my monthly chart.
• When i click on data on Monthly chart , something is wrong, because it wrongly filter my daily chart: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

[v-cherch-msft]

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

[kchojnowski]

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?

 

[v-cherch-msft]

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

[kchojnowski]

It doesnt work for me.
I sent link to dropbox on priv.

Karol

[v-cherch-msft]

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

[v-cherch-msft]

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

[kchojnowski]

Hi @v-cherch-msft

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

[v-cherch-msft]

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