Forum Discussion
Slicer with duplicate values after sort by column
Hi campelliann,
Apologies, I do not understand what the default slicer selection have to do with sorting of the values?
Please can you share a sample file and a desired solution for us to better understand the problem.
Thank you,
Vishesh Jain
Hi there! This is the slicer. "Mes atual" = Current Month (because we are on 2023-03) it should appear after 2023-02.
This is a way for the slicer to show as default the current month. If had 2023-03 for instance, when we change months on april, the default filter would still be on 2023-03, but this way the filter will be on april. I cannot go with the filters options of showing the current month, as this would disable the user to see previous or future months.
The problem is the sorting on the slicer, which it seems to me I only be able to solve it if i create a sort table connected to the calendar and without duplicates... A solution I am seeking to avoid...