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
a
(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
a
(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