how do i change layout of table visual in powerbi

[fstupot]

hi guys,

im quite new to powerbi and i am really struggling with the table visual.

i literally want to show the data below......but with months as the columns and the combined total for each "ganger"

so i can see the monthly cariance. its easy enough to show in bar charts but i cant understand how i do it using the table visual

please help x

[v-kelly-msft]

Hi @fstupot ,

Is your issue solved now？

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Tahreem24 · Accepted solution]

@fstupot ,

Try Visual Matrix to collapse and expand the icon, Screenshot is attached to put the column names according to your need.

[Daviejoe]

Change the visual type to the Matrix visual, it is to the right of the standard table in the visuals selection area.

You can then drop months into the columns section.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

I'd suggest you create a date table.

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/