How to show columns with no data in Report Builder?

[aishahslmn]

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

Company	January	February	March	April	May
A	124		242	165

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

Company	January	March	April
A	124	242	165

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

Thanks in advance.

[lbendlin]

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