Answered

Filter Chart Data by Single Field

(0) Share

Report

Posted on by PhotoRonin

I have a data set that contains player scores for various games that are played. I've created a sample data set below. I have a line chart that I'd like to show pieces of this data, but am having a problem with filtering based on the "Game Type" to only show stats from a specific game.

GameType	Player	10-Point	20-Point	30-Point	Date
PP180	Bob@something.com	10	8	5	2022/08/15
PP180	Mark@something.com	9	8	8	2022/08/14
PP180	Bob@something.com	10	7	6	2022/08/13
ActivPlay	Bob@something.com	0	0	0	2022/08/12

Based on the data above, I'm able to show the 10-point values over time by setting the chat's "item" to: 'Player Scoress'.'10-Point'

What I need to be able to do is only show the 10-point values for 'GameType = PP180' and 'Player = User().Email'

What would I use as my "items" value for the line chart?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Gochix 1,935 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @PhotoRonin ,

Your Items value for Line chart :

Filter(YourSPList,GameType = "PP180" && 'Player Scores'.'10-Point' = 'Player Scores'.'10-Point' && Player = User().Email)

Was this reply helpful? Yes No
PhotoRonin 33 on at

Like (0)

Report
Copy link

Link copied!
Thanks for the reply, but this does not appear to work for me (leaves a yellow exclamation mark on the chart). The data source is the Dataverse, and the source table is "Player Scoress", so I updated the "items" property of my chart like so:
Filter('Player Scoress',GameType = "PP180" && 'Player Scoress'.'10-Point' = 'Player Scoress'.'10-Point' && Title = User().Email)
...what am I missing, or what data can I provide to help solve this? It's a chart, and not a gallery of items.

Was this reply helpful? Yes No
Verified answer

PhotoRonin 33 on at

Like (0)

Report
Copy link

Link copied!
Adjusted, and now it works, thank you!!
Filter('Player Scoress',GameType = "PP180" && '10-Point' = '10-Point' && Title = User().Email)

Was this reply helpful? Yes No