Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Experts,
1. I need help to Un-Pivot the a lengthy pivot table in PBI.
2. See color coding in the input & Output. But Yellow colored is the Region name, see the link to excel / PBX file for what header IsEqual = what Region.
3. I may have to inlude more columns in any of the part of this excel. Hence, the solution may be a flexible to unpivot more columns.
Power BI PBX sample Files ->https://1drv.ms/u/s!AkBVVNsuRUvzbBndSCMWArFt8Zo
Sample file in Excel --> https://1drv.ms/x/s!AkBVVNsuRUvzcY-nNxEoK_Jouvw
I am neither a developer nor a PBI expert. Help will be appreciated
P.S. : Just back to using PBI after a longtime 🙂
Thanks
Chandan.
Solved! Go to Solution.
Hi@Chandan
According to your description ,follow my steps and give it a try as below: Step 1: Duplicate three table based on you input table like this:
Hi@Chandan
According to your description ,follow my steps and give it a try as below: Step 1: Duplicate three table based on you input table like this:
Hi Lin @v-lili6-msft ,
While I am trying on my database your suggestion, is it possible to post the excel fiile that you have used ?
I tried to us my excel through edit queries however, there is this two error of Key / Table.
Thanks,
Chandan
Hi,@Chandan
This is the excel fiile :
https://www.dropbox.com/s/drekyxfz1fb63sh/New%20Microsoft%20Excel%20Worksheet.xlsx?dl=0
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |