Table Visualization

[snoopyine]

Hi,

I have a little problem and I hope someboday can helb me.

I need the following sheet

                                     Year 2017                      Year 2018

                                     Costs  | Sales  | EBIT   || Costs  | Sales  | EBIT   || 

Product No 1  | Name 1  |

Product No 2  | Name 2  |

My problem is when I use the visual "tabel" , then I see only the Product No or the name, but no both. And the visual "matrix" don't help too.

Thank for your help

[v-piga-msft · Accepted solution]

Hi @snoopyine,

It seems that matrix is the visualization what you want. I made some data to create the visual below.

To create the visualization above, you should put your fields in the places highlighted in red and do drill down. You also should turn off the Stepped layout in Row headers like below.

In addition, you could refer to my test pbix file.

Best Regards,

Cherry

[mdave]

Hello,

I have a datatable with client number, date, balance etc.  What I want to do is make a table with Rows as Client Number, Data, Balance. 

Like

ClientNumber X

Date 1/1/1900

Balance $230

but while using visualization - Table, it puts values as Client Number, Date, Balance as column and I can't change it.

Like:

ClientNumber Date           Balance

X                      1/1/1900   $230

Matrix doesn't help.  Why is it so hard in Power BI to swap Rows and Columns in table?  I don't want to unpivot the data in query editor.  This is visualization thing.  Any suggestion?  explanation?

[v-piga-msft · Accepted solution]

Hi @snoopyine,

It seems that matrix is the visualization what you want. I made some data to create the visual below.

To create the visualization above, you should put your fields in the places highlighted in red and do drill down. You also should turn off the Stepped layout in Row headers like below.

In addition, you could refer to my test pbix file.

Best Regards,

Cherry

[snoopyine · Accepted solution]

Thanks 🙂 

I don't turn off the Stepped layout in Row headers 😕  

[jthomson]

The matrix sounds like what you want, you just need to put your various fields in the right places and then drill down until you get to see it in the format you want