Forum Discussion
Show table numbers until selected date
Hey, Im trying to use a table visual, im trying to show the dates until the selected month of my filter, is it possible to do something like that without using mutiple selection?? ...
hi Anonymous
For your requirement, you need a separate date table for slicer.
Try this way as below:
Step1:
Create a separeate date table then use it as slicer.
Step2:
Create a meausre as below:
Forflag = CALCULATE(MAX('Table'[Date]),FILTER('Table','Table'[Date]<=MAX('Date'[Date])))Step3:
Drag this meausre into table's visual level filter and set is not blank
Result:
Regards,
Lin
hi Anonymous
For your requirement, you need a separate date table for slicer.
Try this way as below:
Step1:
Create a separeate date table then use it as slicer.
Step2:
Create a meausre as below:
Forflag = CALCULATE(MAX('Table'[Date]),FILTER('Table','Table'[Date]<=MAX('Date'[Date])))Step3:
Drag this meausre into table's visual level filter and set is not blank
Result:
Regards,
Lin
Thats it!!! it worked, thank you so much v-lili6-msft