If filtered table in(PowerBIIntegration.Data) has no selected value, return no items in Power Apps gallery

(0) Share

Report

Posted on by Community Power Pla...

Hi!

I have a gallery in Power Apps with 'Items' field which return an Excel/Power BI table:

Filter(DependenciesSE_Step2,DependenciesStep2 in(PowerBIIntegration.Data).DependenciesStep2)

I have a multi-selections slicer in Power BI for that table and when the users filters values their are reflected in the Power Apps gallery (working fine).

BUT, if the users hasn't selected anything in the Power BI slicer, the Power Apps gallery will return all values from the table by default until a value is selected in Power BI/Apps. It's invalidating my calculations in the app since I'm looking for user inputs (filtered value only)

Is there a way for the Power Apps gallery to only show selected values and return none if none are selected?

I really need help with this, been investigating this for days! 😩

Thanks.

Alex.

I want the gallery to filter only the selected values in Power BI (which is working fine), but