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

Filtering for Charts Help

Hi Everyone,

 

I am trying to create a bar chart that only shows information from the last 30 days (or even better having the ability to filter the chart to any month range). I have something set up currently and it is not showing anything. The error I receive is "Unexpected characters. Characters are used in the formula in an unexpected way".  The choice column I am referencing in Sharepoint is "OnHoldReason" since I want to show a chart of the reasons why something was put on hold. The sharepoint list is titled "MaterialRefill_1". Please see my code below.

 

 

AddColumns(GroupBy(AddColumns(Filter(MaterialRefill_1,Created>=DateAdd(Today(),-30,Days)),"SelectedONHOLDReason",OnHoldReason.Value),"SelectedONHOLDReason","ONHOLDReasonList"),"ONHOLDReason",CountRows(ONHOLDReasonList)))

 

2 REPLIES 2
mdevaney
Super User
Super User

@kkrushinsky 

Can you please share a screenshot of the formula with red lines?  Seeing where the dark red line helps me know where exactly the error is.

See photos below. The red underline is at the very end of the code. I also included a picture of what the chart output looks like (which is nothing basically right now).

10-12-2020 3-58-36 PM.png10-12-2020 4-00-33 PM.png

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,542)