I am new to power bi and i am facing one issue on running total..
Here source is like this
open_Date, reqest no, status
My rquirement is find the running sum for all issues based on the issue status...
i i click the status "OPEN" then the same graph should show the "open " issues running sum. same for remaing status ...
Please help me how to do this ...
When you say running total of the SUM, can you tell me what are you trying to SUM???
Hi Thank you..
I have a requirement to filter the entire dashboard based on request status.
i have proivded only request no, open date and status.
i have to filter the running total SUM using the "request status".
i have tacken the status in normal slicer or ChicletSlicer. based on the selection of the status the running total graph should be changed. for example the total running SUM of all issues is 120 by default it shows the graph up to 120 or all open dates.
if i click the "OPEN" status then it will display the running total sum 24 like that for all respective open dates...
If I understood you correctly you just need to use a slicer for it:
Select Slicer from visualisations and drop your Status field in it:
Is this what you were looking for?
I assume that all this data pulled from the same table right.
If so just double check 2 things:
1st check if you haven't turned off filtering interactions on the bottom chart
and if this all ok then 2nd thing to check your measure or what are using to populate the total count of statuses???
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.