Forum Discussion

GAURAVG's avatar
GAURAVG
Helper I
4 years ago

Date Slicer with multiple columns

Hello all, I have a table "Table1", which has few requirements and 3 columns having the dates in which they were in various states(draft,inProgress,closed).See table below. I then have 3 visuals da...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, GAURAVG 

 

If you want to use date slicer, the context will change, and you won't be able to filter multiple columns of data in one step.

There are a simple workaround, but you need to use the measure to all visuals' filter pane.

Create a single date table, and create e measure to filtere three date columns in filter pane.

Like this:

 

 

Table 2 = CALENDARAUTO()
Measure =
IF (
    MAX ( 'Table'[Draft] )
        IN DISTINCT ( 'Table'[Draft] )
            && MAX ( 'Table'[InProgress] )
                IN DISTINCT ( 'Table 2'[Date] )
                    && MAX ( 'Table'[Closed] ) IN DISTINCT ( 'Table 2'[Date] ),
    1,
    0
)

 

 

 

 

 

If the relative date is fixed, you can use the calculated column to filter in all visuals.

Like this:

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

 

Best Regards,
Community Support Team _ Janey

GAURAVG's avatar
GAURAVG
Helper I
4 years ago

Thank you for the reply. My relative date is not fixed.

But if you see from your calculated column example, after i filer for "Last 3 months"R4 is also considered for Draft and In Progress visuals..But for R4 Draft was way back in Aug(08), and hence in the visual, it should not show up.

Also for the measure,I would however have to create arelationship between the Table2 and table 1.Else i wont be able to apply filter on visuals.Isnt that correct?