Answered

Line chart - Series filtered values

(0) Share

Report

Posted on by bangorkeith

Hi,

I've gone round in circles quite a bit on this already so hopefully someone can help! I have a sharepoint list with a date, measure and value columns which I have used to populate a few simple bar charts by filtering the measure column. Now I want to create a line chart showing 2 of the measures on the same chart. The issue I'm having is that the values for both measures are in the same column so when I go to select the series on the line chart I can only select that one value column.

I feel like I basically need to create a table/collection for the chart which has date, measure1 and measure2 columns as the items property for the chart but I am really struggling to do this!

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bangorkeith ,

Could you please share more details about your scenario? Which columns would you like to set as the X and Y axis of the line chart?

I assume you will only need to use Value as Y axis, so basically you will need to generate a two columns collection with only Measure1 values and Measure2 values. So below will be the basic formula:

ClearCollect(col1, [1,2,3,4,5]);ClearCollect(col2, [6,7,8,9,10]);Clear(col3); ForAll(Sequence(CountRows(col1),1) As aaa,Collect(col3, {Measure1:Last(FirstN(col1,aaa.Value)).Value,Value2:Last(FirstN(Measure2,aaa.Value)).Value}))

Now we could get a 2 columns collection and use as the Items of the chart:

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
bangorkeith 91 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I have tried something similar but the problem is there is also a date column which needs to be used as the label property. What ends up happening when I build the collection like that is that the date labels are all repeated and the 2 lines basically sit alongside each other rather than above and below (if that makes sense!)

Was this reply helpful? Yes No
bangorkeith 91 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

What I had tried before clearly wasn't similar enough! I've used your method and was able to add in the relevant dates as well and it's working like a charm, phew!

Thanks

Was this reply helpful? Yes No