Forum Discussion
Solved
Automatic change filter
Hello good afternoon
I would like to know if you have how to configure a filter to be alternating at a certain automatic time?
every day I have to log in to the power bi and change these filters manually
Hi CPDAlpina ,
You may create a measure like DAX below, assuming the <Filter value1> is referred to the filter condition you will set, and then put it into the Filter Pane.
Measure1=SWITCH( MAX([Shift]), "morning", <Filter value1>, "Afternoon", <Filter value2>, "Night", <Filter value3>)Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi CPDAlpina ,
You may create a measure like DAX below, assuming the <Filter value1> is referred to the filter condition you will set, and then put it into the Filter Pane.
Measure1=SWITCH( MAX([Shift]), "morning", <Filter value1>, "Afternoon", <Filter value2>, "Night", <Filter value3>)Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Hi there
You could use the relative Date Slicer which will update when your dataset gets updated.
Here are more details on how to use it https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-rangeHello good Morning, not quite what I need, I'll explain it better: I have the filter per shift in this report, Shift 1 - morning Shift 2 - Afternoon Shift 3 - Night this report is being presented automatically on a TV, but I have to keep changing this shift manually when there is a shift change.
