web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter Chart Data by S...
Power Apps
Answered

Filter Chart Data by Single Field

(0) ShareShare
ReportReport
Posted on by 33

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.

GameTypePlayer10-Point20-Point30-PointDate
PP180Bob@something.com10852022/08/15
PP180Mark@something.com9882022/08/14
PP180Bob@something.com10762022/08/13
ActivPlayBob@something.com0002022/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:
I have the same question (0)
  • Gochix Profile Picture
    1,935 Moderator on at

    Hi @PhotoRonin ,

     

    Your Items value for Line chart :

     

     

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

     

  • PhotoRonin Profile Picture
    33 on at

    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.

  • Verified answer
    PhotoRonin Profile Picture
    33 on at

    Adjusted, and now it works, thank you!!

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
wolenberg_ Profile Picture

wolenberg_ 119 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 107 Most Valuable Professional

#3
Haque Profile Picture

Haque 103

Last 30 days Overall leaderboard