Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Freeze row headers in tabel visuals

Hi guys,

 

This question is been asked several times but is mostly about freezing the colomn headers. I would like to know if there is a way how to freeze the row headers in either 2 as 3 dimentional visual tabels in Powerbi.

 

I have a date slicer and when selecting a year that does not contain any data in the relationship tabel SALES, i see an empty visual tabel, but what I would like, is to see the row headers titles even with no data.

 

Thanks in advance

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , I doubt there is much you can do on that, other than default functionality.

  • Thejeswar's avatar
    Thejeswar
    Icon for Super User rankSuper User
    4 years ago

    Hi Anonymous ,

    You can enable the "Show Items with no data" property for the Year Column

    An Example screenshot below

    Source:

    For this example, I have enabled "Show items with no data" property for the Task column. In your case it will be the column that you are using

    Empty row displayed:

    Regards,

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      In this case i dont have a Task slicer but a year slicer containing 2019, 2020 en 2021. 

       

      The source tabel is something like this:

      Task  HRS  Year

      A        14   2019

      B        11    2020

      C                2021

      D        13    2021

       

      Year slicer selected value:

      2021

       

      Visual shows:

      Task HRS

      D   13

       

      Visual should show:

      TASK   HRS

      C

      D     13

      • Thejeswar's avatar
        Thejeswar
        Icon for Super User rankSuper User
        4 years ago

        I tried with the data that you shared, it is working as expected

        Although you are slicing on Year, since your Table is not having year, you should set the "Show items with no data" property to enabled for Task

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  Anonymous ,

    You may also consider using a literal "Blank()" instead

    Here are the steps you can follow：

    1. Create measure.

    Hrs_measure =
var _select=SELECTEDVALUE('Table'[Year])
var_sum1=CALCULATE(SUM('Table'[HRS]),FILTER(ALL('Table'),'Table'[Year]=_select&&'Table'[Task]=MAX('Table'[Task])))
return
IF(
    _sum1=BLANK(), "Blank()",_sum1)

    2. Result:

    Best Regards,

    Liu Yang

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