Forum Discussion

samantha75's avatar
samantha75
Frequent Visitor
2 years ago
Solved

Insert Blank lines in Matrix Financial Statement

Hi Everyone Thanks for helping me out with the fin rpeort and I'm very close to the final version. One question I  have is inserting blank lines to separate row sections for example insert a line be...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi samantha75 ，

    If you want to add blank columns to Reporting Heading, you can manually add blank rows to Reporting Heading in the dataset.

    And then add an index column, sort it, and return to desktop to generate blank rows.

     

    Hope it helps!

    Best regards,
    Community Support Team_ Tom Shen

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

     

samantha75's avatar
samantha75
Frequent Visitor
2 years ago

I think my requirement is not clear. How do you add a blank row in matrix report? for example see below example for the format required after adding the blank rows (in Yellow):

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi samantha75 ，

    If you want to add blank columns to Reporting Heading, you can manually add blank rows to Reporting Heading in the dataset.

    And then add an index column, sort it, and return to desktop to generate blank rows.

     

    Hope it helps!

    Best regards,
    Community Support Team_ Tom Shen

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

     

    • samantha75's avatar
      samantha75
      Frequent Visitor
      2 years ago

      Thanks It looks like we cannot insert a completly blank column (not showing the index on screen)

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi samantha75 ,

        I think your understanding is correct, as I am doing now, I am adding a lot of blank rows to the data, but in power bi these blank rows are automatically aggregated, so referencing the index column is necessary.

        Hope it helps!

         

        Best regards,
        Community Support Team_ Tom Shen

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