Forum Discussion

CPDAlpina's avatar
CPDAlpina
Regular Visitor
5 years ago
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...
Need Help
  • v-xicai's avatar
    v-xicai
    5 years ago

    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.

     

v-xicai's avatar
v-xicai
Community Support
5 years ago

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.