Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I'm very new to Power BI.
I'm trying to create a Matrix that extracts the below Excel data and outputs to the following table, so I can create a few visual graphs from the 2nd table.
Would really appreciate someone to guide me please as I'm a beginner. Thanks in advance !
Solved! Go to Solution.
Hi @Dante79,
Please follow this link. Hoping you wil get solution of your problem.
https://community.powerbi.com/t5/Desktop/Merged-Cells-in-Source/td-p/194473
If any concern revert me back.
Best Regards,
Ravi
Thanks for your prompt reply !
I tried some of the steps in the link and managed to merge the columns into one but still can't figure out how to achieve the output table view that I desired.
Thanks Ravi !
You've been a great help ! Really appreciate the gesture to do a video call to teach me step-by-step too. Two thumbs up !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |