Forum Discussion
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 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!
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
2 Replies
- amitchandak
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