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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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