Single date Slicer for Table Visual

[Anonymous]

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:

[VictoriaNguyen]

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

[BA_Pete]

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]

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]

@Anonymous 

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

Date picker tutorial 

[Anonymous]

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]

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.

[Anonymous]

Hi @Icey ,

I was looking for an option by which i can select a single date like below:

Which would Filter out my table visual like the one below:

 Using calendar by tallan would use up too much space in the page. 

I was looking for something like our normal slicer.

The slicer as you'd already know allows only 'before', 'after' and 'between' options with a calendar view.

As shown in this video:Date picker tutorial  by GuyinACube, the date slicer with 'after' option can be modified to pick a single date(by using a measure with min function). But this method can be used for visuals like cards where measures can be used. For visuals like tables iam not sure if we can use a measure like this and achieve this.

Thanks

[Icey]

Hi @Anonymous ,

I got it. Try this:

1. Create a Date slicer with "after" mode like that in the video.

2. Create a measure to filter table visual.

Measure 2 =
IF (
    MAX ( 'Calendar'[Date] ) = MINX ( ALLSELECTED ( 'Calendar' ), 'Calendar'[Date] ),
    1
)

Best regards

Icey

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

[Anonymous]

Hi @Icey ,

The issue is, the table in your video shows a summarised value(84,14 etc..). Iam working with a normal table which doesn't show summarised values but individual lines.Like the on below:

I believe measures always gives a summarised values.

When we have to show individual values with seperate lines  is there a workaround we can do for achieving this?

Thanks for the Replies.

[Icey]

Hi @Anonymous ,

In the following .gif file, all columns in the table are "Don't summarized" and the method I posted above works well. Does this method not work in your situation?

Best regards

Icey

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