Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 class | Productoption | Revenue | Order intake | Order backlog |
has always values | has always values | sometimes blank | sometimes blank | sometimes 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!
Solved! Go to Solution.
@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
@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
thank you very much, it worked perfectly!
just quick add on... the filter must be "is not 3"