Forum Discussion
Filter precedence for PowerAutomate
Hi onlycallisto,
Since report level filters in Power Automate do not override pre-applied blank filters, my previous suggestions wouldn’t work as intended. Your goal is to have a default state of no data, but still allow Power Automate to dynamically apply valid filters.
Instead of setting a pre-existing filter in PowerBI, a better approach would be to use a DAX-based conditional filter that only hides data when no external filter is applied.
Use this DAX measure:
DataVisibility =
IF(
COUNTROWS(ALLSELECTED('Table'[provider_name])) = 1,
1,
0
)Now apply this measure as a filter on all report visuals. Go to filters pane and add "DataVisibility" as a Visual-Level Filter for all visuals and set the filter condition to "DataVisibility = 1" and then publish the report.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
Hi onlycallisto,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.