Forum Discussion
Matrix Visualization Multiple Columns & Rows of Data
I am using the Matrix visualization to present Revenue, COGS, Processing Cost, Gross Profit Margin Data. I've changed the Matrix values to "Show on Rows" so that the headers are in the first col...
You can search for a visual in the market place or try to create a table like this and display
union
(
summarize(table,"Name","Revenue","Amount",[Revenue Amount],"per ton",[Revenue Per Ton],"% of Revenue",[ % of Revenue])
,summarize(table,"Name","COGS","Amount",[COGS Amount],"per ton",[COGS Per Ton],"% of Revenue",[COGS % of Revenue])
,summarize(table,"Name","Processing Cost","Amount",[Processing Cost Amount],"per ton",[Processing Cost Per Ton],"% of Revenue",[Processing Cost % of Revenue])
,summarize(table,"Name","Gross Profit Margin","Amount",[Gross Profit Margin Amount],"per ton",[Gross Profit Margin Per Ton],"% of Revenue",[Gross Profit Margin % of Revenue])
)
I will research this more to see if this provides what I need.