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.
Hi Everyone,
I posted a similar question a little while ago but never was able to get to a solution. I am looking to show cumulative sales by customer since January 1, 2018 on a bar chart using the play axis to see how the customers compare over time. I have a cumulative measure that shows the cumulative sales over that time and it is correct. That measure is,
Solved! Go to Solution.
@Anonymous , I think you have to use an independent date table for the slicer on which play axis will run
Example
Cumulative Invoiced for PLAY =
var _max = MAXX(allselceted(Date2) , Date2[Date])
return
CALCULATE(
[Total Revenue $$$ (CAD)],
DATESBETWEEN(
CalendarDate[Date],
MIN(CalendarDate[Date]),
MAX(CalendarDate[Date])
) , CalendarDate[Date] <=_max
)
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
That worked wonderfully! Thank you.
For future viewers of this form, there is a typo in the DAX code proposed. It should say "ALLSELECTED".
Thanks again!
Could you please describe what did you exactly do here? I've been trying for about few days already but nothing seems to be working with Play Axis.
Please see the photo bellow. What I'm aiming to do here is to hit 'Play' Button and show title race in EPL 2022-23. Now you see number of points as of now. However, when I click play Axis it shows me number of points at one certain date, not cumulative number.
Also, please not that for the visual I'm using not Horizontal Bars but table, bars are coming from conditional formating as it was the only way to show teams icons.
@Anonymous , I think you have to use an independent date table for the slicer on which play axis will run
Example
Cumulative Invoiced for PLAY =
var _max = MAXX(allselceted(Date2) , Date2[Date])
return
CALCULATE(
[Total Revenue $$$ (CAD)],
DATESBETWEEN(
CalendarDate[Date],
MIN(CalendarDate[Date]),
MAX(CalendarDate[Date])
) , CalendarDate[Date] <=_max
)
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |