Hide rows where all data is blank or = 0 for table graph

[Anonymous]

Hello,

I have created a table graph in Power BI and many of the rows are either blank or equal to 0 and I wanna know if there is a way to tell PBI to just skip these rows and don't show them.

PS: The data I hid is text and the results are correct in having 0 as value (or blank).

[Ashish_Mathur · Accepted solution]

Hi,

Write a measure to add the numeric column: total = sum(Data[value]).  Thereafter you can apply a visual filter on the numeric column to only show values greater than 0.