Further advance filtering on Charts

(0) Share

Report

Posted on by OsmandFernando

Dear @PowerAddict

Based on your and others wonderful support I made the following,

Collection to find sales by location
Collection to summarize the sales by location
Chart to show the summary sales by location

I want the location chart to filter based on the Year selection in the dropdown. In the location summary the SalesYear column has under the group. I tried following way but did not work

If(Dropdown2_1.Selected.Value="All",SalesSumbyLocation,Filter(SalesSumbyLocation, Grouped.SalesYear = Text(Dropdown2_1.Selected.Value)))

It says under the = sign invalid argument type

Kindly help

Osmand

Categories:

Building Power Apps

All responses (20)

Answers (1)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

What happens when you try without the Text function?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com
OsmandFernando on at

Like
a
(0)

Report
Copy link

Link copied!

@PowerAddict same error brother, invalid argument type
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Ok. Two questions:

1. Show me your SalesSumByLocation collection by going to View->Collections

2. Show me the items property of Dropdown2_1

Thanks,
Hardit
OsmandFernando on at

Like
a
(0)

Report
Copy link

Link copied!

@PowerAddict

There you go

1.

2. Item property set as
["All","2019","2020"]
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Ok so the problem is that your year numbers are in decimal format. You need to first change them to numbers without decimals.

Try something like:

Left(Find(Grouped.SalesYear), ".") instead of Grouped.Sales in your filter expression.

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com
OsmandFernando on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @PowerAddict I tried but did not work

If(Dropdown2_1.Selected.Value="All",SalesSumbyLocation,Filter(SalesSumbyLocation, Left(Find(Grouped.SalesYear),".") = Text(Dropdown2_1.Selected.Value)))

I think left function is not complete. Also I tried as below,

If(Dropdown2_1.Selected.Value="All",SalesSumbyLocation,Filter(SalesSumbyLocation, Left(Find(Grouped.SalesYear),".",4) = Text(Dropdown2_1.Selected.Value)))

Did not work

Osmand
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

My bad, yes the Left function was incorrect. Try this:

If(Dropdown2_1.Selected.Value="All",SalesSumbyLocation,Filter(SalesSumbyLocation, Left(Grouped.SalesYear, Find(Grouped.SalesYear,".")) = Text(Dropdown2_1.Selected.Value)))

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!
Hardit Bhatia
https://www.thepoweraddict.com
OsmandFernando on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @PowerAddict

But still the = sign says Invalid argument type
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Do me a favor please. On either side of the equation, if you keep your cursor, it should tell you the data type. Let me know what those are.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com
OsmandFernando on at

Like
a
(0)

Report
Copy link

Link copied!

@PowerAddict

It is Control