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 filtering by the desired month the second requirement should have the option to show Weekend Only or Weekdays Only

 

The 3rd requirement (not filter) would be calculated column to display Dates (Mon to Sun) based selected requierements from the option above.

 

Thanks...tksnota01

Need Help

5 Replies

  • tackytechtom's avatar
    tackytechtom
    Most Valuable Professional
    1 year ago

    Hi tksnota01 ,

     

    I think this video here should do the trick for the first part:
    Show last 6 months in Power BI based on slicer selection and make number of months dynamic

    For the weekend part, I would add such an attribute directly to your calendar/date dimension (such a table is always a good idea to have anyway).

     

    Let me know if this helps your if you get stuck somewhere.

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

  • 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.