Forum Discussion
Date slicer is not changing date when selecting other slicer
Hello all,
We're trying to desing a dashboard in which we have 2 slicers:
1) Date slicer with between option
2) Mosaic slicer in which I can select the Department.
The thing is that as you can see, first date od data set is 01/01/2022 but I want that when I select a Department, the date of Date Slicer changes also.
But this doesn't happens and this feature/bug is just present on this kind of slicer. If I try it with other Date Slicer it works.
Do you know if there is any way to perform this but with first slicer showed?
Thans a lot in advance
Hello all,
Just for your information the solution applied was:
1) Created required slicers
2) Go to Format3) Selecting Department, enable filter bottom of Date Slicer
Neither any additional tables.
I've checked using bi-directional relationship and it worked. But then i've tried removing this bi-directional relationship and it worked also. I don't know if it worked without bi-directional relationship, but maybe data as it's cached and if data is updated it'll fail.
Anyway, the general solution is proposed one and with bi-directional relationship.
Thanks a lot to everyone for feedback
8 Replies
That is a question for your data model, your selected fields, and then search/filter direction.
BTW, your desired behavior is considered sub-optimal for Power BI performance.
Hello lbendlin,
The thing is that i want that when I select a department, the date on slicer change also without any interaction on this slicer.
I don't understand the reason of this commented sub-optimal performance due to it's that happens in others date slicers. Do you know if this requeriment is possible?Best Regards
It is possible but potentially undesirable.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hello all,
Just for your information the solution applied was:
1) Created required slicers
2) Go to Format3) Selecting Department, enable filter bottom of Date Slicer
Neither any additional tables.
I've checked using bi-directional relationship and it worked. But then i've tried removing this bi-directional relationship and it worked also. I don't know if it worked without bi-directional relationship, but maybe data as it's cached and if data is updated it'll fail.
Anyway, the general solution is proposed one and with bi-directional relationship.
Thanks a lot to everyone for feedback
