Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Convert a single column to multiple table columns

I’m still fairly new at PBI, and find it’s a great tool, especially since we often work with millions of records, but I do have a situation I need some help with.   I have a table in which I may ha...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous Steps to take in Edit Queries

    1) Highlight "Value" column and under the Transform toolbar click "Unpivot Columns"

    2) Go to Add Column tool bar - click "Index Column" (this will add an index column to your dataset

    3) Highlight the Attribute and Index columns, right click and "Merge Columns" (Pick a delimiter)

    4) Hightlight the Value and Merged columns, go back to the Transform toolbar, click "Pivot Column"

    the "Value" column should be in the Values Column selector, click open Advanced options -> select "Don't Aggregate" from the dropdown. - click OK

    Your output should look like this:

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous Steps to take in Edit Queries

1) Highlight "Value" column and under the Transform toolbar click "Unpivot Columns"

2) Go to Add Column tool bar - click "Index Column" (this will add an index column to your dataset

3) Highlight the Attribute and Index columns, right click and "Merge Columns" (Pick a delimiter)

4) Hightlight the Value and Merged columns, go back to the Transform toolbar, click "Pivot Column"

the "Value" column should be in the Values Column selector, click open Advanced options -> select "Don't Aggregate" from the dropdown. - click OK

Your output should look like this:

Shipra361's avatar
Shipra361
Frequent Visitor
3 years ago

Hi, is it possible to plot such values in power bi? 
I have a situation where i have to plot mark-up% (measure) against each product id (column). Now there are cases where one product id has multiple mark-ups. Please suggest if it is possible to show that in a scatter plot. For now, i have merged the product ids and mark-up% using a delimeter because mark-up% were showing average (single mark) in scatter plot for product ids which has more than one mark-ups. After merging them, i have placed product id in X-axis, mark-up% in Y-axis and ProductId_markup% in legend to show multiple dots for each product. Also, can you please advise, how can i change the color of these dots to single color because there is no color fx available in power bi. It is impossible to change 1000+ marks one by one