Forum Discussion

AlexLepage's avatar
AlexLepage
New Member
1 year ago

Need Help Freezing header colum in Matrix

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
    AlexLepage
    New Member
    1 year ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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.