Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dear community, i want to make a line chart like this:
Its just a example how I want it. Its a Line chart with the cumalative amount of every year. I want on the X-axis every month. On the Y-axis the amount. And I want lines of the last 3 year, so from 2024, 2023 and 2022.
I cant get it done in PowerBI I tried a lot of measures but no one works for me.
Last Measure I tried is this one:
I already made a Calandertable. So Basicly what I want is a line chart with different lines of years cumalative. And I Mean of every year the line needs to begin at zero
I hope some one can help me! Thank you so much
Solved! Go to Solution.
I am using Contoso database to simulate your case. My Date table has all dates present in sales table(Order Date).
Date table is linked to sales table one to many(Single). Sharing explanation below.
Step1: Setup data model as stated above.
Step2: In date table sort the Month name column with month no, so that months appear sorted on your visual.
Step3: Create this measure.
Measure
------------
Hi @jochem_werff,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information and description to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
I am using Contoso database to simulate your case. My Date table has all dates present in sales table(Order Date).
Date table is linked to sales table one to many(Single). Sharing explanation below.
Step1: Setup data model as stated above.
Step2: In date table sort the Month name column with month no, so that months appear sorted on your visual.
Step3: Create this measure.
Measure
------------
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
User | Count |
---|---|
71 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
24 |