Forum Discussion
Filtering on multiple dates using a single date slicer
Hello, I have 3 dates within my table ie. Ordered date, shipped data and recieved date. I need to filter all the 3 dates using one date slicer. Data in Power BI is being pulled from SSAS tabular ...
Hello v-frfei-msft
Sorry for the late response. I could meet the above requirement by using "Pivoting". I transformed all my date columns into row clubbed them under "Activity Date" and used this Activity date in my date slicer.
You'd make a date table as normal, and relate that to your ordered and shipped fields to it. Then, in your date table, make a custom column that reflects the 60 day offset, and relate that new column to your received date. Sticking the first column from your date table into your slicer should then do the trick
Hi,
I am not able to give relation twice to the same date.I am able to fetch minimum date value from the slicer range but not able to obtain the 60 days offset using this min date value.
Thanking in advance.