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.
What I want is like a running total in a visual with a legend of year and an axis of months. The user picks the months they want from a page filter and for each month that appears I want to show the total of that month and all the previously appearing months.
so if I choose March, June, and september from the filter, only 3 months appear in the visual. I want march to show just the total for that month. June shows the total of both March and June. September shows the total of March, June & September.
this is only if the user chooses a selection of months. If the user doesn't use the filter or chooses all 12 months in a year, I want it to show the standard running total.
the two visuals are identical except for the _measure in the values field
here is the page filter
both the page filter and the visual axis are using the same field, so getting a count of the number of distinct values selected in the filter is difficult for me since the visual restricted it to just one monthly value
the monthy values are
Month mmm | Year | _Total_Partner_Payment |
Jan | 2021 | 10938 |
Feb | 2021 | 9962 |
Mar | 2021 | -22864 |
Apr | 2021 | 1571 |
May | 2021 | 3763 |
Jun | 2021 | 2409 |
Jul | 2021 | 7089 |
Aug | 2021 | 2309 |
Sep | 2021 | 3307 |
Oct | 2021 | 4573 |
Nov | 2021 | 0 |
so march should show -22864
june should show -20455 (-22864 + 2409)
sep should show -17148 (-22864 + 2409 + 3307)
as contrasted to the normal running totals
Month mmm | Year | _running_total_Partner_Payment |
Jan | 2021 | 10938 |
Feb | 2021 | 20900 |
Mar | 2021 | -1963 |
Apr | 2021 | -392 |
May | 2021 | 3370 |
Jun | 2021 | 5779 |
Jul | 2021 | 12868 |
Aug | 2021 | 15177 |
Sep | 2021 | 18483 |
Oct | 2021 | 23056 |
Nov | 2021 | 23056 |
Ideally I would have the ability to test for the number of months selected. (0 or 12 would use the standard running total and any number of months between 1 to 11 would just total the selected months on or before that month on the visual for that year.
here are my current measures
Solved! Go to Solution.
@bsheffer
I think you want this way ! attached the pbix file
Proud to be a Super User!
@bsheffer
I think you want this way ! attached the pbix file
Proud to be a Super User!
thanks for your help. Here is my modified measure. My changes in bold. The key was using the allselected function. It ignored the implicit month filter in the visual while still respecting the month page filter values.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |