Get Month Names as columns along with two other columns.

[Anonymous]

I have a requirement for a chart like below –

 

Warehouse and Employee are two different columns which I can pull easily. However  I have Month and totals as two different columns.  I am not able to achieve the above chart layout. When I do a matrix chart, I only get to see one column Warehouse as below – and then I have to Drill down.

Is there a way I can get a chart with Warehouse, Employee and month names as columns.

[TomMartens]

Hey,

the matrix visual is the visual you have to use, maybe you are just missing the drill-down part.

Please read here

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-matrix-visual/

Regards

Tom

[Anonymous · Accepted solution]

Thanks for the response. I got it figured out, I just turned off the stepped layout in matrix visual settings and I got what I wanted.