Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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
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
User | Count |
---|---|
103 | |
87 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |