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 fi...
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-range
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-range
Hello 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.