how to join several colums to make a Clustered column chart

[jppuam]

Hello,

i need your help for a chart that i need to do, regarding several values that are store in various columns, that are separated by this :

debt 1 to 45

debt 46 to 60

debt 61 to 90

debt 91 to 120

debt 121 to 150

debt +150

if make a column chart it is not stay as the same series.... how can i join them to have only 1 serie with this values ?

thanks,

JR

[zlokesh · Accepted solution]

Hi @jppuam,

        There is MERGE function to do the same. Please go through the below screenshot. (in Query Editor)

[v-yulgu-msft]

Hi @jppuam,

In Query Editor mode, please choose all these corresponding columns at the same time, then click "unpivot columns".

Best regards,

Yuliana Gu

[jppuam]

Sorry Yuliana Gu,

but i dont understand, because (i do it wrongly) but he create severa columns but the values were not in the same column.

it should create one column with all the values (like a value column). i dont know if i was clear ?

thank you,

J

[zlokesh]

Hi @jppuam,

    I think you have to use proper deliminator here, Please go through the below screen shot for more information.

(While Get data)

[jppuam]

thanks,

i'll change the data that i've trying to see if it turns more easelly to do that,