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 ,
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