Forum Discussion

dikssha's avatar
dikssha
Regular Visitor
7 months ago
Solved

In between slicer for text values in the date column

I have a date table which has 4 columns - date, year, Month year, Quarter year. Month year has values in the format "mmm-yy" and I want to use the month year column in the in between slicer. I have a...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    7 months ago

    You can’t use an “In between” slicer on a text column like mmm-yy. That slicer type only works on continuous values (Date or Number), not categorical text. What you could is:

    • Use two slicers on Month year (text)

    • One for Start Month

    • One for End Month

    • Apply the range logic in DAX

maruthisp's avatar
maruthisp
Icon for Super User rankSuper User
7 months ago

Hi dikssha ,

Please check the attached pbix file with a solution for slicers with date as TEXT and can select in the slicers.

Please let me know if you have any further questions or need clarifications.

 

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

  • dikssha's avatar
    dikssha
    Regular Visitor
    7 months ago

    Many thanks for the solution.
    However, it wil not serve the purpose because dropdowns are not as user friendly as the slicer. Also, if user select higher value in the first then it will not work. I know that I can create 2 tables and then I can make the first slicer to filter second one but since Power BI does not has a feature of automatic slicer reset, until user will change the option in the second slicer, visual will remain blank.