Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all,
I'm trying to create a cumlative line chart, split by year. I have used the VALUES function in the DAX to define years and I've added 'year' to the legend on the visual. My issue is that the report has a visual slicer for year and my client would like the cumulative line chart to ignore the selection in the year filter i.e. when 2024 is selected in the slicer, it will still show data for 2022 and 2023
Here is my DAX so far. Any suggestions are greatly appreciated.
Cumulative orders=
CALCULATE(
COUNTROWS(Orders),
FILTER(
ALLSELECTED(Orders),
Orders[Order date aligned] <= MAX(Orders[Order date aligned]
),VALUES(Orders[Year])
)
Solved! Go to Solution.
Hi! Check out the ALLEXCEPT function in DAX. You are basically telling it to ignore certain filters: ALLEXCEPT function (DAX) - DAX | Microsoft Learn
Proud to be a Super User! | |
Hi! Check out the ALLEXCEPT function in DAX. You are basically telling it to ignore certain filters: ALLEXCEPT function (DAX) - DAX | Microsoft Learn
Proud to be a Super User! | |
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |