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 methods in the forum, but it seems they all work only for summarised values. Probably for a card which shows a summarised value.

For something like a table, i am not sure how working with measures would help.

I have a date table generated with DAX and the relationship looks something like this:

I have two table visuals. and i wish to filter out both these table visuals with a single slicer which is why i created this date table.

 

My report tab looks smething like this now:

 

 

 

 

 

Need Help

10 Replies

  • BA_Pete's avatar
    BA_Pete
    Super 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.

  • VictoriaNguyen's avatar
    VictoriaNguyen
    Helper I
    4 years ago

    Icey Sorry for the commend on the old post. But when I applied these fields in my table the data is disappear?