Need Help Freezing header colum in Matrix

[AlexLepage]

Hi, 

I need to keep colum header at all time but when filtering down some dissapear. I got a large amount of date for 2 week scheduling that is recurring. How can I make all day appear ever when no data. 

Tueaday of teh second week isnt showing as there is no data. How can I make it appear blank ?

[Anonymous]

Hi @AlexLepage ,

You can set 'Show items with no data' for matrix columns.

This way, columns with no data are also displayed.

For more information, please refer to the following document.

Show items with no data in Power BI - Power BI | Microsoft Learn

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexLepage]

Hi, I've try and it isnt working. I think it is not working because I got two colum header ?

[Anonymous]

Hi @AlexLepage ,

I did not reproduce your problem in my testing.

There are two columns in the matrix and 'Show items with no data' still works.

Could you provide sample PBIX files? We can better understand the problem and help you.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.