Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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
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?
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
Thanks 🙂
I don't turn off the Stepped layout in Row headers 😕
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |