I have a line graph with a SharePoint list as the source. In the list there is a column called type, and it has different names: "A", "B", "C", "D".
How can I make it so that in a text input box, when I type for example "A", the data in the graph is shown related only to this name (that is, the text input is a filter)?.
Hi! First of all, you need to add the TextInput field on your screen. Let's assume it is called TextInput1.
Then you need to go to the Items property of your LineChart control. There would be the name of your data source, in my sample case it is 'Test List'. You need to change it to the formula:
Filter('Test List', Type=TextInput1.Text)
where Type is a name of the column, 'Test List' is the name of the list.
Please note that if your Type column is not a text type, but the choice one, you need to write something like Type.Value instead of just Type in this formula
Let me know if this works!
Was this reply helpful?YesNo
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.
351
Share
Report
All responses (
Answers (
