Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Have you tried using a more explicit data model where you source the month values from the Calendar table?