Dear Mates,
I would like to create the actual line in the graph2 which is similar to graph1. Graph1 shows the actaul line as i expected until current month of the Financial year.
As we can see the graph2 The actual shows the line until 2024 March. I would like to restrict that line to show untill current month of the finacial year and want to make it dynamic similar to graph2
Graph :1 ( Correct or expected)
Graph :2 (Need to Trim/Change)
The Dax measure which i used for calculating Cumulative income for the Graph:2, I mentioned in below.
We need to do filter in the month for limiting curve to show the line until current month of the FY. I'm strugguling to do this, please help me to do solve this issue.
actual_income_cummulative =
CALCULATE(
SUM('analytics commercial_opportunities_graphs_view'[actual_income]),
FILTER(
CALCULATETABLE(
SUMMARIZE(
'Date Opportunity',
'Date Opportunity'[Date Order],
'Date Opportunity'[Date 2]
),
ALLSELECTED('Date Opportunity')
),
ISONORAFTER(
'Date Opportunity'[Date Order], MAX('Date Opportunity'[Date Order]), DESC,
'Date Opportunity'[Date 2], MAX('Date Opportunity'[Date 2]), DESC
)
)
)
Note: the above calculation is done using quick measures. Which is already available in power bi.
Thanks in advance.
Thanks in advance.
