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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Table Visual with more than one measure... how to delete empty rows when all measures are empty?

Hi guys!

 

I'm currently facing the issue, that a table visual is showing quite a few empty rows that I don't want to display.

The table looks like this:

 

Customer classProductoptionRevenueOrder intakeOrder backlog
has always valueshas always valuessometimes blanksometimes blanksometimes blank

 

My task is to filter rows where revenue, order intake and oder balcklog are either empty.

These three are measures that should rather not be changed. 

 

my first tought was to put a filter for each measure on the table that sais Revenue is not blank , order intake is not blank and order backlog is not blank. 

 

Unfortunately this does not work, as the table now filters all empty revenue rows, regardles if there is a value in the other two. Therefore I'm missing some order intake rows. 

 

is there a way to tell the visual to filter rows if revenue, order intake AND order backlog are empty?

 

Thanks!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , Ideally when all measures are blank, the row should automatically get removed unless you use +0 in a measure or use the option "Show item without data" on right click or not summarized column

 

If it it showing create a measure

 

if(isblank([Revenue]),1,0)  + if(isblank([Order intake]),1,0)  +if(isblank([Order backlog]),1,0) 

 

Now use a visual level filter and hide row where this new measure =2

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Ideally when all measures are blank, the row should automatically get removed unless you use +0 in a measure or use the option "Show item without data" on right click or not summarized column

 

If it it showing create a measure

 

if(isblank([Revenue]),1,0)  + if(isblank([Order intake]),1,0)  +if(isblank([Order backlog]),1,0) 

 

Now use a visual level filter and hide row where this new measure =2

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

thank you very much, it worked perfectly!

 

just quick add on... the filter must be "is not 3"

Chrisgaa_0-1692259384209.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors