Forum Discussion

showard40k's avatar
showard40k
Regular Visitor
2 years ago
Solved

How would you graph this information?

In the attached I have asked 7 employees if they have ever occupied ANY of the 9 specific position over the course of their 10+ year careers: Superior Officer Commanding Officer Delegated Off...
Need Help
showard40k's avatar
showard40k
Regular Visitor
2 years ago

Thanks Ashish. When I opened your PBIX file, I noticed you used "unpivoted other columns' under Transform Data. In my file, I am using a lot of other changes in "Transform Data" and I think "unpivoted other columns'  will affect my other graphs in my PowerBi dashboard. Is there a way to apply "unpivot other columns" in such a way that it won't affect my other graphs that are using my data? 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Your solution is so great Ashish_Mathur

Hi, showard40k 

 If you do not want the unpivoted other columns to affect your report, you can perform the following operation on your original table in Power Query:

You can apply the super user method to this new query table, so that your original report will not be affected. At the same time, if your original table updates data, this new query table will also be updated.

 

 

Best Regards

Jianpeng Li

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