Forum Discussion

rajasekaro's avatar
rajasekaro
Icon for Helper III rankHelper III
5 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
    5 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

     

cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
5 months ago

Format pane → select the Month field in columns → right-click the Month field in the Columns well → uncheck "Show items with no data"