Forum Discussion
PowerBI - Matrix table blanks
- 1 year ago
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
Are blanks among the column values or are they visible only due to invalid relationships?