Forum Discussion

aishahslmn's avatar
aishahslmn
Frequent Visitor
3 years ago

How to show columns with no data in Report Builder?

Hi all, 

 

I have created a report in power bi desktop but I want to recreate the report as a paginated report in report builder. In power bi desktop, I can visualize my table with columns with no data (refer table below as an example).

 

CompanyJanuaryFebruaryMarchAprilMay
A124 242165 

 

But in the report builder, the table is like this (refer table below)

CompanyJanuaryMarchApril
A124242165

 

How do I make the columns with no data shown on report builder?

 

Thanks in advance.

1 Reply

  • Have you tried using a more explicit data model where you source the month values from the Calendar table?