topic Re: Filter Slicer based on value on another slicer seems not work on me (a bug?) in DAX Commands and Tips

Filter Slicer based on value on another slicer seems not work on me (a bug?)

aghnamahardhika — Fri, 12 Jul 2024 08:24:30 GMT

Hello Power BI community,

So here is the situation,

I wanted to filter the date so that if I choose either "MTD" or "YTD", the date filter will be turned off. Only when I select "Period" will the date filter can be used.

I followed some YouTube tutorials like:

and they provide a quite straightforward way to do it.

So, what I did is I created a measure as follow:

CustomDateDisable = INT(SELECTEDVALUE('MTD or YTD'[MTDORYTDORPERIOD])="Period")

The measure seemed to work well for me. Proved by the value of the CustomDateDisable card:

The problem came when I tried to put the CustomDatefilter measure on Date filter. The date filter seems to ignored the MTDORYTDORPERIOD value and only depends on how I choose the value on the CustomDateDisable pane.

I really appreciate if there is someone to correct my logic or the implementation to this case.

Thank you in advance.

[UPDATE]

Hey Power BI community,

I update the case for an important context.

It seems that I encountered some type of bug.

When I changed the field to something other than Date, the filter worked perfectly to disabled the slicers.

Also, the filter still worked fine when I changed the field to date, but the style I choose was vertical list or tile

Only when I change the style to between, before, after, dropdown, relative date, or relative time, that the filter start to not working.

Hopefully anyone on this forum can notice.

Thank you in advance.

Re: Filter Slicer based on value on another slicer seems not work on me (a bug?)

Anonymous — Mon, 15 Jul 2024 08:24:14 GMT

Hi aghnamahardhika ,

In order to get a better understanding on your problem and make further troubleshooting, could you please provide the following info?

Are the field [MTDORYTDORPERIOD] and [Date] in the same table?
The field [MTDORYTDORPERIOD] is a calculated column or fact field of the table?
Could you please provide your sample pbix file?

Best Regards

Re: Filter Slicer based on value on another slicer seems not work on me (a bug?)

aghnamahardhika — Mon, 15 Jul 2024 08:42:00 GMT

Dear Anonymous ,

1. The field [MTDORYTDORPERIOD] and [Date] are on different table.

2. The field [MTDORYTDORPERIOD] is a fact field on the table. I made a small excel table and then linked it to Power BI.

3. I send it on the DM since it may contain pretty sensitive data.

Best Regards,

Aghna Mahardhika