Forum Discussion

rajasekaro's avatar
rajasekaro
Helper III
4 months ago
Solved

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 ...
Need Help
Tips and Tricks
Tutorial Requests
  • pankajnamekar25's avatar
    pankajnamekar25
    4 months ago

    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

     

v-abhinavmu's avatar
v-abhinavmu
Community Support
4 months ago

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.