Forum Discussion

Hoppsan's avatar
Hoppsan
Regular Visitor
2 years ago

Dual month filter in same visual

Hi,

I am a fair beginner at Power BI but trying to learn.
I want to build a visual in Power BI where I can filter column 1 from one slicer and column 2 from another slicer. Column 1 would be a starting month and column 2 would be an ending month and then these two are compared against eachother. 

Is this possible? Or would there be a smarter way to do it?

Need Help

1 Reply

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution Sage
    2 years ago

    Hoppsan What is currently happening is that table is giving every value that has a selected start and end date. It is not taking every data from start to end. Need to create a measure using calculate where the filter is for min date [selectedvalue(comaprison start month)] and max date [selectedvalue(comparison end month)].