Forum Discussion
Helper IIISlider - Does not take into consideration the data range selected
Hi,
This is because as you said in your orginal post, you do not want the audience to go to prior years data.
So if you do not apply this filter to the card visual, when end users select the start date in 2019 in date slicer, the card will show the total sum of values including data in 2019.
If you using other visual such as table visual, it is the same principle.
For example, when you choose the start date from 2019/1/1, the table and card visual still show the data that start from 2020/1/1, Which will protect the data in 2019.
Best Regards,
Giotto Zhi
Community SupportHi,
Please try to add this filter to the Card visual instead of Slicer.
And it works well when you choose 2020/1/1:
Best Regards,
Giotto Zhi
Helper IIIThank you Giotto! This helps.
Question - But why do we need a date filter in the card visual? As it has 1:Many relationship the slicer when selected between 01/01/2020 - 12/31/2020 should show data only for this period and not the entire fact table. I don't understand why is this filter needed in the card visual at all.
- v-gizhi-msft
Hi,
This is because as you said in your orginal post, you do not want the audience to go to prior years data.
So if you do not apply this filter to the card visual, when end users select the start date in 2019 in date slicer, the card will show the total sum of values including data in 2019.
If you using other visual such as table visual, it is the same principle.
For example, when you choose the start date from 2019/1/1, the table and card visual still show the data that start from 2020/1/1, Which will protect the data in 2019.
Best Regards,
Giotto Zhi