Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic Column values based on Slicer Selection

Looking for a solution for the below given problem:-   I have a around 12 columns in a dataset which are plotted in a line chart. Out of this 8 are P1 and 4 are P2 category.   I need to slice the...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    Anonymous 

     

    You may aslo try Unpivot Columns in Query Editor, then take advantage of the Legend field.

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
6 years ago

Anonymous 

 

You may aslo try Unpivot Columns in Query Editor, then take advantage of the Legend field.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Unpivoting is the solution, but the problem is size of data. by unpivoting it has 25M rows.