Forum Discussion
Solved
PowerBI - Matrix table blanks
Hi, I have a matrix table on PowerBI and I have columns in it from multiple data sources. I also have some filters. I want to get rid of the blanks when filters are applied etc. Is there a way t...
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
