Matrix Grouped Column issue: Columns are appearing with Gap in between.

[GyanendraMaurya]

Hi, I'm working on a Power BI paginated report.

I have a Matrix with a column group. This Matrix has three parent groups. Grouped columns are dynamic as its number of columns can increase or decrease based on its parent groups. This metrix is to be replicated for multiple times based on the iteams selected in the parameters.

Now because based on parent groups all columns will not be a part of each replication on matrix.

Example: Prt Group1 -- Prt group2-- Prt group3--Matrix with 3 columns,

Prt Group1 -- Prt group2-- Prt group3--Matrix with 6 columns,

Prt Group1 -- Prt group2-- Prt group3-- Matrix with 4 columns

Now when data is displayed in report Columns are not staring from the 1st place from where column1 should started instead, if it is on the 5th place or as per the auto sort; is starting from nth place having first few column space as blank. These few blank space are left because in same report's another set of matrix replication will have those few columns which are not part of first matrix replcation. Similarly in each set of data displayed in the matrix columns are getting spread out.

Ex:

Parent group 1

Parent group 2

Parent group 3

(Set 1) Metrix Data: Gap Gap Column1 Column2 Column3 Column4 Column5

                                                data             data      data         data         data

Parent group 1

Parent group 2

Parent group 3

(Set 2) Metrix Data: Column1 Column2 Gap Gap Gap Column3 Column4 Column5 Column6 Column7

                                  data             data                            data        data        data          data          data

I would like to know how to start each column from its first place in each set with out any gap.

Please suggest can this be achieved in Power BI paginated report?

Thank you for time.

[GyanendraMaurya]

Hi All,

I'm still struggling to achieve this format in PowerBI paginated report, anyhelp would be approciated.

Thank you!

[Greg_Deckler]

@GyanendraMaurya Do you need to trim your data? Seems like you have some extra white space?

[GyanendraMaurya]

Hi Greg,

Thank you for your response however there are to no white spaces to be trimmed. When I'm runnning report for a single value (Single Matrix) then results are displayes correctly.