Forum Discussion
PowerBI - Matrix table blanks
Hi sd_09 ,
Thanks for reaching out to the Microsoft fabric community forum.
I tested the scenario using the following sample data:I then created a calculated column to flag rows with at least one non-blank value:
ShowRowFlag =
IF (
NOT (
ISBLANK ( OrgData1[Score1] ) &&
ISBLANK ( OrgData1[Score2] ) &&
ISBLANK ( OrgData1[Percentage] )
),
1,
0
)
I added this column as a visual-level filter, and set it to show only where ShowRowFlag = 1.
And got the result like below. Please go through the pbix file
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support Team
I need to see some images describing the thing please
This is the table
This is when I filter on something:
The rows are organizations. I want to get rid of the blank rows/organizations when I filter
The images should show the entire table/visual otherwise I cannot understand
This is the table:
and this is what happens when I filter:
Is this clearer?
Hi sd_09 ,
Thanks for reaching out to the Microsoft fabric community forum.
I tested the scenario using the following sample data:I then created a calculated column to flag rows with at least one non-blank value:
ShowRowFlag =
IF (
NOT (
ISBLANK ( OrgData1[Score1] ) &&
ISBLANK ( OrgData1[Score2] ) &&
ISBLANK ( OrgData1[Percentage] )
),
1,
0
)
I added this column as a visual-level filter, and set it to show only where ShowRowFlag = 1.
And got the result like below. Please go through the pbix file
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support Team