Multiple Values for a Matrix can now Appear as column headers

Question

Hello,&nbsp;I have a scenario where&nbsp; 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.&nbsp;Thanks&nbsp;

vanessafvg · Answer

not quite sure what you mean
&nbsp;
i have two dimensions and 2 measures&nbsp; in a matrix that plot okay, what are you expecting it is not clear

&nbsp;
&nbsp;

themistoklis · Answer

Anonymous&nbsp;
&nbsp;
If I understand correctly you want to see two levels of information.
&nbsp;
In the matrix visual and on the top right of the visual click on the drill down icon. Image below:

anonymous · Answer

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.&nbsp;&nbsp;&nbsp;

anonymous · Answer

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

alexisolson · Answer

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).

Forum Discussion

Multiple Values for a Matrix can now Appear as column headers

6 Replies

Related content

Waterfall with multiple values

Multiple Header Column

Text slicer: pasting multiple values

ISFILTERED multiple values

Slicer for Multiple-Choice Values