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 no data. 

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

Need Help

3 Replies

  • 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.