Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi @jppuam,
There is MERGE function to do the same. Please go through the below screenshot. (in Query Editor)
Hi @jppuam,
There is MERGE function to do the same. Please go through the below screenshot. (in Query Editor)
Hi @jppuam,
In Query Editor mode, please choose all these corresponding columns at the same time, then click "unpivot columns".
Best regards,
Yuliana Gu
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
Hi @jppuam,
I think you have to use proper deliminator here, Please go through the below screen shot for more information.
(While Get data)
thanks,
i'll change the data that i've trying to see if it turns more easelly to do that,
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |