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,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you are using filters and if the filtered data contains an incorrectly formatted value, the report should show no data rather than all data. Were you able to go through the solution suggested by GilbertQ.
Apart from the suggested points, you can also try to catch all invalid filter. Instead of using a blank filter, try setting a default filter to "Does not Exist". This makes sure that by default, the report will show no data.
I would also take a moment to thank GilbertQ, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
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.
The issue with using blank or does not exist filter is that the Report Level Filters do not over-ride it when it's run through PowerAutomate. So I just get a blank report for everyone. That is the basis of my question - is there a way to have it default to no data while still making it possible to filter using Report Level Filters?
The suggestion so far is to run a manual test before every execution of the flow, which is time intensive and not the purpose of automation. I could do it that way but it's not really the solution I was hoping for.
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.