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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Can a line chart join ...
Power Apps
Unanswered

Can a line chart join gaps in data

(0) ShareShare
ReportReport
Posted on by 50

I have am charting data from a collection for three subjects representing tests which are taken either in the Autumn term, or the summer term. One of the subjects only tests during the autumn term so that subject has no data for the summer term.

 

When charting the relationship between the test scores, it considers a missing entry as 0, and therefore does this to the chart. Is there a way of getting the chart to join the data points?

 

chart.png

Categories:
I have the same question (0)
  • RogierE Profile Picture
    875 Moderator on at

    You could either calculate and add the intermediate values to your table or add a separate chart for the Ability figures. I would go for the last, as it could be confusing to the user that there is a label for a value that is not in your table. 

    So if you copy your chart, get rid of the title and legend of this copy, and set the grid style to "None", you would get something like this: 

    RogierE_0-1705261683210.png

     

    Of course for this to work you would need to: 

    • filter out the empty values in your second chart, so I added this to the Items property: 
    Filter('New tables',!IsBlank(Ability))
    •  get rid of the data in your first chart, so to the items of that chart I added this:
    DropColumns('New tables',"cr594_ability")
    • connect the MaxY, MinY, X, Y, Height, Width etc of the copy Graph to the original Graph so that they stay aligned. 

    Please like the reply and/or accept it as the solution if the answer is what you were looking for.

  • mrwilliams Profile Picture
    50 on at

    Thanks for the reply @RogierE  - I will have a go this weekend.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard