Matrix table column Hide

[rajasekaro]

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 .  

[v-abhinavmu]

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.

[v-abhinavmu]

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.

[cengizhanarslan]

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

[pankajnamekar25 · Accepted solution]

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