Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
2017-jan-01,1010345, closed
2017-jan-01,1014234, closed
2017-jan-01,1033245,open
2017-jan-04,2035432,rejected
2017-jan-04,2010345, closed
2017-jan-04,3014234, closed
2017-jan-04,3033245,open
2017-jan-05,6035432,rejected
2017-jan-05,6010345, closed
2017-jan-05,6014234, closed
2017-jan-05,6033245,open
2017-jan-05,6035432,rejected
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 ...
Hi @ramutd54,
When you say running total of the SUM, can you tell me what are you trying to SUM???
Regards
Abduvali
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?
Regards
Abduvali
please check the below two graphs...
Please refer the above...
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???
Regards
Abduvali
Hi @ramutd54,
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.
Best Regards,
Dale
the bottom graph shows only running count for all requests
please check the below two graphs...
Please refer the above...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |