cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

how do i change layout of table visual in powerbi

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

 

 
 

powerbi screengrab.JPG

 

1 ACCEPTED SOLUTION
Super User II
Super User II

@fstupot ,

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

Capture.PNG

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
You can follow me on LinkedIn
Please take a quick glance at newly : HR Analytics Report , Hotel Management Report, and Sales Analysis Report

View solution in original post

3 REPLIES 3
Community Support
Community Support

Hi @fstupot ,

 

Is your issue solved now?

 

Best Regards,
Kelly

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

Super User II
Super User II

@fstupot ,

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

Capture.PNG

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
You can follow me on LinkedIn
Please take a quick glance at newly : HR Analytics Report , Hotel Management Report, and Sales Analysis Report

View solution in original post

Super User I
Super User I

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/





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

Proud to be a Super User!




Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors