Multiple Values for a Matrix can now Appear as column headers

[Anonymous]

Hello,

I have a scenario where  I have to have two headers for one table report in power BI which should look like below. Any idea how do I achieve this? I have created Matrix report but I couldn't have two environment names. I was able to use a field as coulmn and row but not two. Any help would be greatly appreciated.

Thanks

[jaipal]

hi @Anonymous , you can simply achieve this through M queries.

I hope you looking something similar like this

If you have sample date would be helpful

[vanessafvg]

not quite sure what you mean

i have two dimensions and 2 measures  in a matrix that plot okay, what are you expecting it is not clear

[Anonymous]

To add on to the topic, sample would look like this below.

[AlexisOlson]

This is one dimension on the Columns (Category), one dimension on the Rows (Region), and three separate measures in the Values field (Sales, Profit, Discount).

[Anonymous]

Thank you for response. But I dont want two levels of information meaning I dont need a drill down instead everything should be one single report and no drill down allowed. 

[themistoklis]

@Anonymous 

If I understand correctly you want to see two levels of information.

In the matrix visual and on the top right of the visual click on the drill down icon. Image below: