Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Slicer

Hi    I am trying to set up a slicer which filters the week number across two data sets combined into one report.  I have orders put through counted by username and orders not put through coun...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  Anonymous ,

    I created some data:  

    orders not put through: 

    orders put through: 

    You can try to create a calendar table, use the week of the calendar table as a slicer, and create a measure to mark it. 

    Here are the steps you

    1. Create calculated table.

    Table = CALENDAR(MIN('orders not put through'[date1]),MAX('orders put through'[date2]))

    2. Create measure.

    Flag = 
    VAR _select=SELECTEDVALUE('Table'[WEEK])
    return
    IF(
        WEEKNUM(MAX('orders not put through'[date1]),1)=_select || WEEKNUM(MAX('orders put through'[date2]),1)=_select,1,0)

    3. Put [Flag] in the Filter of the two visual objects and set is =1. 

     

    4. Result: 

    Please click here for the pbix file 

    If I have misunderstood your meaning, please provide your pbix without privacy information and desired output.

     

    Best Regards, 

    Liu Yang 

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly