different types of multiple visuals filtering with a date segmentation

[kitti]

Hello experts,

I'd like to know how to create a date segmentation that can handle different visual criteria.

For example, suppose I have a dashboard, which consists of 4 visuals and a date segmentation. If I select 30-APR-2020, the 2 visuals will display the data for the last 2 weeks of the selected date (16-APR to 30-APR) while the rest show the data on that date (30-APR).

We appreciate any help

Thanks a lot.

In

[v-easonf-msft · Accepted solution]

Hi, @kitti 

Please refer to this demo.  pbix attached

If it helps ,try the following  steps:

1.copy out table2 and use the field of table2 to create table visual

Table 2 = SELECTCOLUMNS('Table',"Date",'Table'[Date],"Type",'Table'[Type])

2.create a visual control measure and apply it to the new table visual pane

Measure =
VAR s_date =
    SELECTEDVALUE ( 'Date'[Date] )
VAR t_date =
    CALCULATE ( MAX ( 'Table 2'[Date] ) )
RETURN
    IF ( ( s_date >= t_date - 14 ) && ( s_date <= t_date ), 1, 0 )

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VasTg]

@kitti 

I wouldn't change anything on the date dimension but change the mesures used in the 2 visuals to calculate for past two weeks based on the selected date. 

The  logic should be in the measures/axis columns used in the tile.

[kitti]

@VasTg 

Thanks for reply

How about the date slicer? Currently, it is controlling the whole page for a date selection. For instance, I filtered the 2 measures in relative date filtering to show data in the last 2 weeks, but I tried to pick a date in March, then the data is disappeared because this month is May.

Thanks,

KL

[VasTg]

@kitti 

Please paste sample input and atleast one expected visual data to better assist you.