Freeze row headers in tabel visuals

[Anonymous]

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

[Anonymous]

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

[Thejeswar]

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]

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]

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

[amitchandak]

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