Custom Report layout

[Smout77]

All,
I've been looking into this for some time without success.
I do have a report which I currently generate in xls.
The report layout is fixed and this is where I'm blocked by using Power BI.
The report shows different regions and different phases in a project.
Initially we get a request, once we start looking into the request it moves to analyse and then further up via -> develop -> create - > Validate -> Implemented
During this chain at any time it could receive a stutus on hold or get rejected.

I have all excel data in a table which is available in Power BI as well.
My issue is about the report creation and layout.

In excel I can put the headers (Validate/Create/Develop/Analyse) in the order I need, I can add a totals row which sums all active cases, I can put all non-active ones below this totals row.

How can I achieve the same report lay-out as in the picture? Is it possible at all?
Some quick guidance or reference would be highly appreciated.
From what I have experianced, Power BI represents the data in a kind of pivot like way which sorts (ie. A-> Z) and does not add a totals row in the middle of a table.

[Anonymous]

Hi @Smout77 ,

If you want to display the special layout, you could try to create a separate table, and create a measure to correspond to the rows in the newly created table.

This is my reply post, you can refer to this method:

https://community.powerbi.com/t5/Desktop/max-and-min-value/td-p/1452038

Best Regards,

Stephen Tao

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

[amitchandak]

@Smout77 , If you are looking for a blank row in between that would be challegence, maybe a data point need to be made null using isinscope sepcific value

Sub total you should able to get , refer -https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual