Building a Bar Chart from Sharepoint Data List

(0) Share

Report

Posted on by LaingBennett

Hi there,

I have a SharePoint list of data which is set up in the following way.

Sharepoint Data Table.jpg

What I want to be able to do is chart a bar chart with the months of the year along the bottom Jan-Dec and then the value. TheChart would be able to be filtered by two drop-down menus - one for Event and the Other from Financial Year.

I am trying the following but am struggling as to how to get the months of the year along to the bottom of the chart.

Filter('2020 - Historical Data - Master' , Event = Historic_Data_MONTH__2_DD.Selected.Value && 'Financial Year' = Historic_Data_MONTH_DD.Selected.Value)

The Dropdown that controls the Event has the following in.

["VALUATION", "TAKE ON", "SSTC", "EXCHANGE", "VIEWINGS"]

and the Dropdown that controls the year as the following in.

["VALUATION", "TAKE ON", "SSTC", "EXCHANGE", "VIEWINGS"]

Any help would be gratefully received.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @LaingBennett :

Do you want to show 12 series from Jan. to Dec. in a Column chart?

I'm afraid that is not available ,because one Column chart only support at most 9 series.My alternative is to combine two Column charts.I'v made a test for your reference:

Column chart1

Column chart2

The result

Best Regards,

Bof

Was this reply helpful? Yes No
LaingBennett 84 on at

Like (0)

Report
Copy link

Link copied!

Hi there,

Thank you for this.

I didn't realise there was a limit to the number of series in the Chart.

Regards

Was this reply helpful? Yes No