Forum Discussion
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 counted by username.
when I go to filter by week it only filters one at a time.
does anyone know the soloution for this?
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
6 Replies
- tamerj1
Community Champion
Hi Anonymous
the week column from which table? What is the relationship between the two tables? Do you have a date table?
Hi,
so I have two duplicate datasets. One for "orders not put through" one for "orders put through".
On both of these tables there is a column for Week 1-52. The relationships I currently have are between user ID and Department.
currently, my slicer for week when applied only works for one data set and not the other. I've tried all sorts to try and resolve (including amending relationships) but nothing worked, I suspect it's fairly simple. But just cannot figure it out.
- tamerj1
Anonymous
Can share a screenshot of your visual? Also you did not answer one of the questions, the week column in the slicer belongs to which table?
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
