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

     

pankajnamekar25's avatar
pankajnamekar25
Super User
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