Forum Discussion
Matrix table column Hide
Hi Team
in matrix Visual i dont have a value for some column how to hide that column
example :
if i dont Filter any month In month filter then November to March this column no need to show Because ther is no data
if i select any month then that month value only need to show .
Hello rajasekaro
try this approch
Update your measure to return BLANK()
Sales Amount =
VAR Result = SUM(Sales[Amount])
RETURN IF(Result = 0, BLANK(), Result)Then
Turn OFF Show items with no data
Matrix visual → Click Month field in Fields pane → Uncheck Show items with no data
If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.
Thanks,
Connect with me on:
LinkedIn
4 Replies
Hello rajasekaro
try this approch
Update your measure to return BLANK()
Sales Amount =
VAR Result = SUM(Sales[Amount])
RETURN IF(Result = 0, BLANK(), Result)Then
Turn OFF Show items with no data
Matrix visual → Click Month field in Fields pane → Uncheck Show items with no data
If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.
Thanks,
Connect with me on:
LinkedInFormat pane → select the Month field in columns → right-click the Month field in the Columns well → uncheck "Show items with no data"
Hi rajasekaro ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.Hello rajasekaro,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to cengizhanarslan & pankajnamekar25 for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
