(Matrix) table with total values and grouped values

[Anonymous]

Hi,

I am trying to rebuild an Excel table in a Power BI visual (Matrix Table). But I am facing an issue with the non grouped values. The total value, stock and overdues are the current situation and not to be included in the month columns.  

The Excel table I would like to build in Power BI.

(Different measures are used to calculate the values in the table.)

My current result in Power BI

The total (kg); Stock Qty and Overdue Qty should be in a separate group and not included in the monthly groups.

Anyone an idea? A different visual? A DAX trick?

Thx!

[Anonymous]

Thanks for the replies guys! I hope MS brings us a solution soon. For now I will use two different tables.

(I will vote for your idea's.)

[v-eachen-msft]

Hi @Anonymous ,

Power BI doesn't support it currently. You could vote for the following ideas to improve Power BI and make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39773011-hybrid-table-matrix-and-table-together

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6669480-optional-combo-chart-visuals

[amitchandak]

I do not this is possible unless there is custom visual available. I create an idea for this, please vote for that

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39773011-hybrid-table

[vivran22]

Hello @Anonymous ,

I do not think that any native visual in Power BI supports this. 

You may alternatively try creating two separate visuals (a combination of a table and a matrix visual).

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn