Forum Discussion
Helper IIIValues in Particular column needs to changed as separate columns.
Hi..
I have the below tables which i have called this from APIs.. I am unable make them seperate columns. Could anyone help. Tried Pivoting but it not worked.
Now i need the above data as to be formed like below. Categories must be didvided seperately as new ones.
If anyone knows, kindly help here.
Thanks
Hi Sudharshan1919 ,
The reason may be two rows that were pivoted had same value, resulting in dupe column names, you can check this similar thread for your reference:
According to the screenshot you just started, you can directly click [value.capabiliyies.nae]-select Pivot Column
Values Column – [value.capabilities.value]
Advanced options – Aggregate Value Function -- Sum
Result：
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Sudharshan1919 , select the last 2 columns and then pivot.
Last column should be used for value with Sum
If not
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
refer
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
Sudharshan1919Got the required format but getting the below error when Pivoting the elements.
Used the below options.
Hi Sudharshan1919 ,
The reason may be two rows that were pivoted had same value, resulting in dupe column names, you can check this similar thread for your reference:
According to the screenshot you just started, you can directly click [value.capabiliyies.nae]-select Pivot Column
Values Column – [value.capabilities.value]
Advanced options – Aggregate Value Function -- Sum
Result：
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
