Automatic change filter

[CPDAlpina]

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

[v-xicai · Accepted solution]

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.

[GilbertQ]

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

[CPDAlpina]

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.