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
In this case you need to manually filter them out. Anyway you could solve in Power Query and not see them in Power BI Desktop or in Desktop filter hem out from the filters pane
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
I think i incorrectly phrased my question, so there is data generically but when I filter on lets say a location, some rows dont have data. I would like to filter those rows out when data is filtered
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 filterThe images should show the entire table/visual otherwise I cannot understand