Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Nielf
Helper I
Helper I

Ignore blank column/field in embedded report with contextual filtering in Power Apps

I am playing around with the functionality to embed a Power BI report on a form in a Power Apps model-driven app. I am using contextual filters (JSON filter string), so the report is filtered based on fields/columns of the current row/record.

 

It works well and I am currently using two fields/columns on the form to filter the report.

 

However, there might be use cases, where one of the fields/columns might be left blank on the form since it is not required. In this case the report doesn't show any data since the filter will show -1, if the column is left blank.

 

Nielf_2-1693920425689.png

Is there any way to ignore blank fields/columns when filtering the report and avoid the -1 filter? Perhaps using some of the advanced filter options?

0 REPLIES 0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.