For eg: My excel table consist
Status of request Month
I want to show Total Requests and only closed requests on the line chart using 2 lines with month wise. when I am doing this the values are equal for toal and closed one it changes automatically.
Go to Solution.
Out of my understanding you need two line 1. Total requests 2. Closed requests.
First you need to filter out the Closed Request from your available requests using an IF statement.
Now you'll be having two columns one with total requests and one with Closed requests.
To get use two columns as values in a Line Chart you need to use PowerKPI visual. Drop the month column on axis feild and remaining two columns as KPI Indicator fields.
Hope this resolves your problem.
View solution in original post
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.