Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have data in below format and I am struggling to create a simple bar chart where I can have month,Year on X axis and Region or Business unit on Y axis. Any ideas on how I can restructure the data in Power BI. I have month as columns and year on rows.
Solved! Go to Solution.
HI @Anonymous
One way would be to make two copies of this table in Power Query. Filter the first where the attribute column contains the text "-Qty" and filter the other where the attribute column contains the text "-Revenue".
Then you can merge the tables (horizontally) using a full outer join and match on the first three columns. This should give you something pretty close to what you need. 🙂
Power Query is pretty powerful
HI @Anonymous
Go into the Power Query Editor, select your first three columns in the preview grid and then hit the "Unpivot other columns" button.
This should pivot your month column data around onto rows where it will be much easier to work within your charts
@Phil_Seamark Thats great. thank you. But I have one other issue here. In the below image, other than qunatity as attribute, I have other facts like revenue which is where having chanllenge on reporting on quantity , revenue separately. Highly Appreciate your help! Thanks
HI @Anonymous
One way would be to make two copies of this table in Power Query. Filter the first where the attribute column contains the text "-Qty" and filter the other where the attribute column contains the text "-Revenue".
Then you can merge the tables (horizontally) using a full outer join and match on the first three columns. This should give you something pretty close to what you need. 🙂
Power Query is pretty powerful
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |