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

[adityo]

Hi Power BI Experts,

I need to create blank rows in matrix visualization like this, and bold in some gl account by using measures: 

This is my table looks like

[PaulDBrown]

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

[amitchandak]

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

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