Error on unpivot the data for selected columns in edit query

[infantpowerbi]

Dear All,

I am infant to Power BI and my data is in below format.

Company Q2 FY 2018  Q3 FY 2018  Q4 FY 2018  Q1 FY 2019  Q2 FY 2019  Q3 FY 2019
X                    0                   0                  0                  0                  0                   0
Y                    0                   0                  0                  0                  0                   0 
Z                    1                   2                  0                  4                  5                   0   
All                  0                   1                  3                  4                  2                   5 

And when I unpiviot for selected columns(Q2 FY 2018  Q3 FY 2018,Q4 FY 2018 , Q1 FY 2019 , Q2 FY 2019 , Q3 FY 2019) in Edit Query I get the below error . Can any one please help in knowing what's the issue and how can I solve it
Error

[v-xuding-msft · Accepted solution]

Hi @infantpowerbi ,

The error pops up because Power BI will automatically create relationships. You could change it to many-to-one between MYT and Mytable. Or you could delete the relationship.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi 

To fix this issue in Relationships by changing the Cardinality to 'Many to One'. 

If still not able to fix the issue please share the PBIX file to fix the error. 

Note: If this post helps, then please consider Accept it as the solution to help the other members find it

[infantpowerbi]

Jagdesh,

Tq for your kind and gentlesupport,Please find the below link and you can find the table MYT in dataset
https://www.mediafire.com/folder/rp3zlge0rx64x/

Tq and regards,

Siddiq.

[Anonymous]

Hi Siddiq,

please Share your Daashboard.xlsx as well as i am not able to load the data from Power BI.

Regards,

jagadesh.M

[infantpowerbi]

Updated the ULR

[Anonymous]

Hi Siddiq,

Please give some shared link to upload the PBIX file. 

Regards,

Jagadesh.M