Forum Discussion
Dynamically select column based on slicer for regression/correlation calculation
Hi, I have approx 400 columns & thousand of rows. All column have numerical value. My Requirement is that, Two slicers which select dynamically two different column that will represent as x & y-ax...
tamerj1
Community Champion
Community ChampionGreg_Deckler
You are absolutely right and I am always with simplest possible solution. However, I have noticed that in many cases people where only allowed to create live connections to pre-published datasets that they don't have the privilege to edit and thus trying very hard to deal with their unpivotted data to perform some sort of aggregation across columns.
One more thing I would like to add is that unpivoting 400 columns using power query is not that efficient. The last time I gave that advise to person in the community he ended up with total crash of his pbix file.
Greg_DecklerCommunity Champion
Community Championtamerj1 Very fair observations. I'm still digging into your code and seeing what it is doing.