Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Single date Slicer for Table Visual

Hi, Is it possible to have a slicer which filters a table visual for a single date. The slicer has options to filter after a date or before a date but not one to pick a specific date. I saw some m...
Need Help
BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
5 years ago

Hi Anonymous ,

 

Sorry if I'm oversimplifying this but, presuming your rlationships are set up correctly (calendar[Date] 1 : * fact[Date]) then you would just use your calendar[Date] field in the slicer and set the slicer to either Dropdown or List.

 

Pete

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi BA_Pete 

Sorry but i need a  date picker kind of slicer. The dropdown and list won't suffice.

I mean the before and after options in slicer gives an option to pick the date from a calendar like a date picker.

This coul be done for summarised visuals like cards. I saw some solutins for cards in the forum and Youtube.

But it seems that can't be done for visuals like Tables which do not summarise.

So i was wondering if there's a way to do this with Tables.

Thanks anyways.

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Anonymous 

     

    Check out this video from Guy in a Cube and see if it helps:

     

    Date picker tutorial 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi PaulDBrown ,

      No it doesn't work. Actually these were the videos i mentioned in my questioned. These all deal with measures and hence summmarised visuals(like cards). I am not sure if this method can be modified to apply in visuals like tables.

      • Icey's avatar
        Icey
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Anonymous ,

         

        I am not very clear about your needs. Please check if below is what you want. If not, please share me a concrete example.

         

        The visual is Calendar by Tallan.

         

         

        Best regards

        Icey

         

        If this post helps, then consider Accepting it as the solution to help other members find it faster.