Forum Discussion
aishahslmn
3 years agoFrequent Visitor
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).
| 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.
1 Reply
- lbendlin
Super User
Have you tried using a more explicit data model where you source the month values from the Calendar table?