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 Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.