cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pasha1
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,044)