Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi, i am still new to power bi and i want to do cumulative line chart . Below is my data(from 1 jan to 30 june) and i need to do cumulative weekly/quarterly/monthly line chart based on country and ast. What i know for now is that in power bi can select only one column, not same as in excel can select for example from 1 jan to 1 feb.
Is there any alternative ways to do, or how do i arrange it in excel so that easier to do in power bi? Thanks in advance.
Solved! Go to Solution.
@camelia_ - Please transpose the data in Power query and you can create the line charts.
1) Go to Power Query editor. Select the two columns - Country and Ast. Right click and select 'Unpivot other columns'.
2. Your table will now look like below. Rename the column 'Attribute' to 'Date'.
3. Close and apply changes
4. Create your Line chart as you desire.
Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.
Also, I would ❤ Kudos if my solution helped. It is a token of appreciation!
Thank you very much !
@camelia_ - Please transpose the data in Power query and you can create the line charts.
1) Go to Power Query editor. Select the two columns - Country and Ast. Right click and select 'Unpivot other columns'.
2. Your table will now look like below. Rename the column 'Attribute' to 'Date'.
3. Close and apply changes
4. Create your Line chart as you desire.
Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.
Also, I would ❤ Kudos if my solution helped. It is a token of appreciation!
Thank you very much !
hi @gauthamboppana , thanks for the solution now i am able to do the cumulative line chart. Is just that why I get the same for all country? The chart suppose to have different line for each country.
And also, i want to do weekly cumulative line chart, i try to use this
Week Number = WEEKNUM ( 'Calendar'[Date] )
but it can't detect the date in the calendar table.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
37 | |
26 | |
23 | |
19 | |
17 |
User | Count |
---|---|
49 | |
40 | |
24 | |
20 | |
20 |