Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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.
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.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.