Forum Discussion
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])
- Anonymous2 years ago
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.
2 Replies
- IdrissshatilaSuper User
- AnonymousNot applicable
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.