Hi @Harsh ,
Thank you for your reply and suggestion!
I appreciate that it is difficult to suggest an approach without looking at the PBIX file.
I have anonymised the content of the PBIX file and attached it for reference now.
Currently I am using a total value per grouping category as the value input to the chart.
Note that since I am using grouping I do not have any active relationships to the calendar.
However, I believe that you showed me a way out of this.
What I believe I have to do is to create a new measure for the grouping category, which is filtered on the selected year and the previous year.
Do you believe that this sound like good approach?
The measure used as value input to the chart is this;
Receivables Per Group Overdue =
VAR _Overdue = CALCULATE( [Invoice Values Days Left],
FILTER(
Invoices,
COUNTROWS( FILTER( ‘Aging Groups’, [Days Left] < 0 ) ) ) )RETURN
IF( _Overdue = BLANK(), 0, _Overdue )
Note that I have tried the solution provided in the topic below, but I was not successful in implementing it. I never fully understood why I didn’t get this to work, but I suspect that it might be due to lack of an active link to the calendar…?
Show SelectedYear and Future Years data in Bar Chart - DAX Calculations - Enterprise DNA Forum
Kind Regards
Arve
Accounts Receivable Insights_EDNA_DEMO.pbix (1.6 MB)