Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
I've got the following table in excel:
What I need to do is to show in a line chart graph the 3 amounts.
But the first must be accumulated, for example:
In month 1 I've got 54 (4+46+4)
In month 2 Iv'e got 91 (1+89+1) but in the chart month 2 must have the value of month 1 + month 2 : 54+91=145. And so on, in Month 3 = month 2 + month 3
Month 4 = month 3 + month 4
etc..
Is it possible?
Do I have to do something in the excel file or directly in power bi?
Kind regards
Solved! Go to Solution.
Hi,
One way to do this would be to create three separate measures in Power BI with the following code:
Measure1=Calculate(Sum('TableName'[Amount1]);
Filter(All('TableName'[Month]);
'TableName'[Month]<=MAX('TableName'[Month])
)
)
Substitute 'TableName' with the name that your table has when imported into Power BI.
Then Measure2, Measure3 similar but use columns Amount2, 3...
Create the visual by adding a line chart and put Month on Axis and the three measures in Values.
Br,
Magnus
Hi,
One way to do this would be to create three separate measures in Power BI with the following code:
Measure1=Calculate(Sum('TableName'[Amount1]);
Filter(All('TableName'[Month]);
'TableName'[Month]<=MAX('TableName'[Month])
)
)
Substitute 'TableName' with the name that your table has when imported into Power BI.
Then Measure2, Measure3 similar but use columns Amount2, 3...
Create the visual by adding a line chart and put Month on Axis and the three measures in Values.
Br,
Magnus
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |