Create blank rows after certain GL account by using measures in an matrix visualization

Here is one way/hack.
In my example, this is the basic fact table:

 

Create a new table with the row structure including the blank rows (I just created this in Excel and copy/pasted it into a new table using the "Enter data" option under Home in the ribbon).

 

 Leave this Row Table unrelated in the model:

Next create the following measure to use in the table visual:

 

 

 

SumValue =
CALCULATE (
    SUM ( FTable[Value] ),
    TREATAS ( VALUES ( 'Row Table'[RCategory] ), FTable[Category] )
)

 

 

 

Create a table visual using the fields from the Row Table and the [SumValue] measure.

 Turn off the word wrap options in the formatting pane:

Now hide the Order column by dragging the right boundary left as follows:

It will also work with the matrix layout, though you have to turn off the "Word Wrap" option for the Row headers (and the stepped layout turned to off)

 

 

I've attached the sample PBIX file

adityo , refer Curbal's excel integration in app , I think that can help

https://www.youtube.com/watch?v=IISYzTaIyu4