Forum Discussion

User1245's avatar
User1245
Regular Visitor
1 year ago
Solved

Filtered Accumulation in DAX

Hello,   I'm trying to create a cumulative chart where the X-axis displays every week of the year, and the Y-axis shows cumulative results. For example, if I have 2 results in week 01/2023, I want ...
Need Help
  • User1245's avatar
    User1245
    1 year ago

    Hey guys! Here's my data model. All columns are text, except "Datas": 

    "Semana/Ano" means "Week/Year". "Datas" mean "Dates". Both reports are connected by "Dates". I used your tips and got two different results: 

    The "Year" slicer functions correctly on both charts.
    However, the other slicers only work on the top chart, which displays non-cumulative data. In both charts, the bars represent actual results, while the line indicates the target. 

    My database originally had each "Event" as separate columns with corresponding dates. I’ve unpivoted the data into Events and Datas.

User1245's avatar
User1245
Regular Visitor
1 year ago

I just posted my data. Your insight helped me make the Year slicer work, but I still face the same problem with the other slicers ðŸ˜•

lbendlin's avatar
lbendlin
Super User
1 year ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523