Forum Discussion
Slicers Not Working Correctly
I have a simple model. Sales and calendar tables. The calendar table was created using calendar auto and marked as the date table. Whenver I select a specific row in the table for the year 2021, the year slicer still shows every week for the year. data does not exist for them yet. I tried a single and bi-directional relationship. Is this a bug?
9 Replies
- amitchandakSuper User
Anonymous , Sometimes table to slicer interaction are not on. Check that.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Also do not prefer bi-directional join. You can take a measure from fact and add a visual level filter in the week slicer for that measure is not null.
refer this example for the way, work for one slicer too -https://www.youtube.com/watch?v=cyOquvfhzNM
- AnonymousNot applicable
These changes make no difference.
- AnonymousNot applicable
That video seems to be showing somethig that has been a default behaviour, when you select the year, you should only be able to select week 5 because no other weeks exist from a data perspective.
- AnonymousNot applicable
Anonymous please share the details of the relationship you have between the sales and calendar tables (i.e. what are the key fields being related?)
- AnonymousNot applicable
they are linked by date fields. The date in calendar and the transdate in sales.
- AnonymousNot applicable
Ok Anonymous, you're going to have to provide a little more information if we're going to be able to figure this out...
What is meant by "the year slicer still shows every week for the year"? Can you provide a screenshot unexpected results you're seeing?
- FarhanAhmedCommunity Champion
Try using "Power Slicer" from Marketplace if you can, and put measure as a filter in it.
This will filter out Slicer selection upon any selection made on other visuals.
- AnonymousNot applicable
Hi Anonymous ,
The information you have provided is not making the problem clear to me. Can you please explain with an example?
Can you share some sample data and the expected result to have a clear understanding of your question?
Best Regards,
Yuna