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
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.
Anonymous
I understand your frustration and sorry for asking many questions. I know it is sometimes more difficult to express and explain a problem than solving.
The reason for receiving such error is that there is already a relationship between both tables. Can you please confirm which columns are involved in this relationship?
In general for such cases you have to have a Date table the filters both tables and then use this table in slicing and dicing in your visuals. Please share some sample data of the two tables and advise the code of both measure in order to simulate the situation to achieve a proper solution. Thank you.