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,
So I have two sets of data, they are for two separate accounts. What I want is that a user can filter on the account and get shown the data from that account. How can I do this? The only way you can see its from a different account is by looking at the header as it says the account name. I want to create another column which will pull only the account name into a row.
Hi @zmukadam ,
You can user the Power Query editor to do the Unpivot the columns so you get the headers in rows.
However if you can share you sample data tables and expected results, it will help understanding your issue better
Regards
Affan
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |