Forum Discussion
Slicer
- Anonymous4 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
Hi Anonymous
the week column from which table? What is the relationship between the two tables? Do you have a date table?
- Anonymous4 years agoNot applicable
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.
- tamerj14 years ago
Community Champion
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?
- Anonymous4 years agoNot applicable
Sorry about that. I have multiple kpi based tables E.G orders put through/not put through via department, and put through and not put through by individual Co-Worker, that can all be filtered by departmet (which works) and then can be filtered by week.
When i filter via week it will only filter one data set E.G. orders not put through and then orders put through will not have responded to the slicer. Both data sets have an existing week column in. I have tried to ammend the relationships between tables (as I thought this was the issue) but this is the error which i get.