Show blank column in the table visuals enabled but it is still not showing up

[Anonymous]

Hello, 

I have different table visuals in my power bi desktop report, all of the table visuals are able to show the blank column for no values/text in the column except one. I have already tried to copy the other similar table and recreate the last one which had issues but it still does not show the blank column.

There are is also another column which uses the same close date for the task with percentages and that has the blank column but the one with just the count of the items does not. Please note that I have tried to replicate and compare the different tables to check and add the similarity but its not working. Can someone please advise if there is a solution for this? Appreciate any insight to get the column visible for the last table.

For example:

Table 1: (Date used is the open date of the tasks)

Department             2024Q2                2024Q3               2024Q4                

ABC                             2                             1

XYX                             1                              4

DEF                             0                              2

LMN                           7                               1

Table 2 (last table): (Date used is the close of tasks)

Department             2024Q2                2024Q3               2024Q4 (this column is not showing up)               

ABC                             2                             1

XYX                             1                              4

DEF                             0                              2

LMN                           7                               1

[Anonymous]

Hi, @Anonymous 

I don't know if this is your table data, but I tested it anyway. I've found that when I put it in a table visual, I can show a blank column even if I don't enable Show item with no data

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

Best Regards

Yongkang Hua

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

[MNedix · Accepted solution]

Heya,

How does the count measure look like? If it's just a simple count then you could consider "tricking" the table with the below:

Count_Forum = IF(ISBLANK(COUNT([Desired_column]))," ",COUNT([Desired_column]))

[Anonymous]

hi @MNedix - thanks, but the count is of an existing column in the table and it is not a formula. 

Is there a way I can use this formula for the closed tasks date and calculate the count? I think this may probably lead to the solution.