Forum Discussion

CEllis's avatar
CEllis
Icon for Resolver I rankResolver I
4 years ago
Solved

Power Bi Report Builder

Hi All,   Not sure if this is possible yet in Report Builder.   The Tablix column heading uses data to group each column on, when data does'nt exist for that column the column no longer appears. ...
Report Builders
  • CEllis's avatar
    CEllis
    4 years ago

    Hi Anonymous 

     

    Thanks for the reply.

     

    Yes thats right, I was hoping to list them so they appear on the PDF report to align table columns.

     

    The only other way I think might work is adding all the possible groups to the dataset with nothing against  them to give the illusion columns have data but with a 0 result in the event they are mssing.

     

    Many thanks

     

    Chris

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi CEllis ,

 

Please correct me if I'm misunderstanding.
Are you expecting to define the columns when data doesn't exist in power bi report builder?
As far as I know this is not possible in Power BI Report builder, if you want to do this with Power BI, you can consider using Power BI Desktop, which supports this feature.

Seeļ¼šShow items with no data in Power BI 

 

Hope it helps,


Community Support Team _ Caitlyn

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

 

  • CEllis's avatar
    CEllis
    Icon for Resolver I rankResolver I
    4 years ago

    Hi Anonymous 

     

    Thanks for the reply.

     

    Yes thats right, I was hoping to list them so they appear on the PDF report to align table columns.

     

    The only other way I think might work is adding all the possible groups to the dataset with nothing against  them to give the illusion columns have data but with a 0 result in the event they are mssing.

     

    Many thanks

     

    Chris