Table Visual - still picking data even though the linked Columns has no value. please help

[ashmitp869]

Hi All,

My report has Year and MonthName filter . This filter are linked to all the expression other than [Total Budget Revenue] and [Total Budget Gross Margin %].

Then why when I select Year 2024 and MonthName June, why I still can see the row...

How can I ommit the rows when all my below expressions has no value . Is it not a default feature in Power Bi Table visual ?

MTD - Billed (Ex-GST])

MTD - Revenue Accrual(Ex-GST)

MTD Total - Revenue(Ex-GST)

MTD - Gross Margin

MTD - Gross Margin %

[Idrissshatila · Accepted solution]

Hello @ashmitp869 ,

try to filter the measure in the filter pane where the value is not blank.

[Anonymous · Accepted solution]

Thank you for your promrt reply Idrissshatila!

Hi @ashmitp869 

I agree with Idrissshatila's idea, I tried to create the data and implement your needs.

First, I have created the following table.

Before using filter:

After:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idrissshatila · Accepted solution]

Hello @ashmitp869 ,

try to filter the measure in the filter pane where the value is not blank.