Forum Discussion
Multi column Matrix or Table
Hi all friends. I have read some discussion posted in this forum and found it is very useful and positive. I've just join the community. I am new in Power BI. I would like to ask the case below. I ha...
There is an option show on row, that should have worked if you only plan to show measure on row.
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
But for this one you might have to create a table
like
union
(
summarize(Table, table[UnitID], "Type", "Unit", "Sold in Period", "Sold in Period", sum(Table[Sold in Period])), // Add other columns in same manner
summarize(Table, table[UnitID], "Type", "SalesAmount", "Sold in Period", "Sold in Period", sumx(filter(Table,Table[Sold in Period]=1),table[SalesAmount])) // Add other columns in same manner
)
use show on row
Thank you for your reply. I will try soon.
Sur