Creating a Bar Chart in Power BI from sharepoint list

[EdwinPolo]

Hi I am trying to create a bar chart in Power Bi, using a Sharepoint List. I have create the next table from sharepoint list columns.

My question is, how can i create a Bar Chart in power bi according to this table. Thank you for your help.

[amitchandak · Accepted solution]

@EdwinPolo , Unpivot the month columns, Then you should be able to easily create a visual

https://radacad.com/pivot-and-unpivot-with-power-bi
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

[EdwinPolo]

Thank to all of you for your support and help.

[Anonymous · Accepted solution]

Hi @EdwinPolo ,

As  amitchandak  mentioned as above, Unpivot your month columns should be a good idea to help you achieve your goal. I think you need to do some other transformation for your table.

1. Select [Contrato] column and Unpivot other columns (Month columns) 

2. Group By your table by [Contrato] column and add a number type [Index] column

For reference: Create Row Number for Each Group in Power BI using Power Query

3. Sort your text type [Month] column by [Index] column.

For reference: Sort one column by another column in Power BI - Power BI | Microsoft Learn

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@EdwinPolo , Unpivot the month columns, Then you should be able to easily create a visual

https://radacad.com/pivot-and-unpivot-with-power-bi
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g