Forum Discussion

Sam7's avatar
Sam7
Advocate II
4 years ago
Solved

Switch between two date options based on Filter

I have read many different versions of this question, this one here nearly gets what I want: https://community.powerbi.com/t5/Desktop/Filter-records-between-two-date-columns-with-one-slicer/m-p/82511...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Sam7 ,

    I updated my sample pbix file(see attachment), please check whether that is what you want.

    1. Create a date type dimension table by Enter data method

    2. Create a date dimension table and apply the date field on the slicer

    Date = CALENDAR(DATE(2022,1,1),DATE(2022,12,31))

    3. Update the formula of measure [qty] and [ssales]

    Best Regards

Sam7's avatar
Sam7
Advocate II
4 years ago

Thanks

 

How do I build this with an option to choose the date tyoe and only one date slicer?

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Sam7 ,

I updated my sample pbix file(see attachment), please check whether that is what you want.

1. Create a date type dimension table by Enter data method

2. Create a date dimension table and apply the date field on the slicer

Date = CALENDAR(DATE(2022,1,1),DATE(2022,12,31))

3. Update the formula of measure [qty] and [ssales]

Best Regards

  • JasonBreedlove's avatar
    JasonBreedlove
    Frequent Visitor
    2 years ago

    After much internet sluething, this is the one that finally solved the issue for me. Of course in my use-case, I didn't need to show the summed column so I just put it in a visual filter and said give me rows that are "not blank"