Forum Discussion

ashmitp869's avatar
ashmitp869
Responsive Resident
2 years ago
Solved

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

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 %

 

 

2 Replies