cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Line chart to skip blanks

Hi everyone,

 

I have two distinct datasets which have different x-values. I would like to plot these on a same line chart. 

So I would like to plot Y , Y2 and Y3 together. 

First, I made Dataset1:

 

ClearCollect(Dataset1,
{X:1.40, Y1:14.49, Y2:12.96},
{X:1.70, Y1:12.01, Y2:11.02},
{X:2.00, Y1:10.06, Y2:9.36},
{X:2.20, Y1:9.00, Y2:8.43},
{X:2.50, Y1:7.72, Y2:7.29},
{X:3.00, Y1:6.20, Y2:5.96})

 

Then Dataset2:

 

ClearCollect(Dataset2,
    {X:2.2, Y3:5.7},
    {X:2.5, Y3:6.7}
    )

 

And finally Dataset3 which combines the two:

 

ClearCollect(Dataset3,{X:Value(Blank()),Y1:Value(Blank()), Y2:Value(Blank()),Y3:Value(Blank())});
Collect(Dataset3,Dataset1);
Collect(Dataset3,Dataset2);
Remove(Dataset3,First(Dataset3))

 

This combines the two tables. Then to plot it on line chart I wrote in Items:

SortByColumns(Dataset3, "X", Ascending)

What I got is this: 

Graph1.PNG

As we can see the graph treats blanks in the table as zeros for plotting:

Table1.PNG
What I would like is for the graph to have only one X value for all 3 series (like for x= 2.2 or 2.5) and to ignore blanks when plotting. So essentially the graph should look like this (made in Excel):

excel.PNG

Does that make sense?

Not sure if that's possible to do on a line chart in PowerApps . Any help would be really appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Line chart to skip blanks

@Pasha1 

I believe @v-xida-msft Microsoft already answered your question "how can I plot blanks" in a PowerApps line chart in your previous question.  The answer appears to be no unfortunately.

 

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/Plot-2-datasets-with-different-x-va...

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

1 REPLY 1
Highlighted
Super User
Super User

Re: Line chart to skip blanks

@Pasha1 

I believe @v-xida-msft Microsoft already answered your question "how can I plot blanks" in a PowerApps line chart in your previous question.  The answer appears to be no unfortunately.

 

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/Plot-2-datasets-with-different-x-va...

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,017)