Forum Discussion

tksnota01's avatar
tksnota01
Frequent Visitor
1 year ago
Solved

Assistance on filter

Hi,   I want to create a single filter that contains these requirements  - first requirement would be classification by 3months, 6 months, 9 months and 12 months based on current date.  - after f...
Need Help
v-menakakota's avatar
v-menakakota
Community Support
1 year ago

Hi  tksnota01 

Thanks for reaching out to the Microsoft fabric community forum. 

 

I would also take a moment to thank  tackytechtom  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

For filtering 3, 6, 9, or 12 months  using a disconnected slicer and dynamic filtering (as shown in the video) is a good approach.

For weekends/weekdays filter adding a column like "Weekday" or "Weekend" to your date table will work well.

Best Regards, 
Menaka.
Community Support Team

v-menakakota's avatar
v-menakakota
Community Support
1 year ago

Hi  tksnota01 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. 

 

Thank you. 

  • v-menakakota's avatar
    v-menakakota
    Community Support
    1 year ago

    Hi  tksnota01 ,

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily. 

     
    Thank you. 

    • v-menakakota's avatar
      v-menakakota
      Community Support
      1 year ago

      Hi  tksnota01 ,

      May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. 

       

      Thank you