Lines in Line and Stacked Bar Chart aren't same as in Line Chart

[Anonymous]

Hello,

In a Clustered Column Chart I use following 
Axis: Month Abreviation
Legend: Year

Values: CUMULATED AMOUNT

CUMULATED AMOUNT is a Measure:

CUMULATED AMOUNT =  CALCULATE( SUM(F_AMOUNTS[AMOUNT]); FILTER( ALLSELECTED(F_AMOUNTS); F_AMOUNTS[MONTH] <= MAX(F_AMOUNTS[MONTH]) && F_AMOUNTS[GROUP] = MAX(F_AMOUNTS[GROUP]) &&  YEAR(F_AMOUNTS[MONTH]) = YEAR(MAX(F_AMOUNTS[MONTH])) ) )

Result:

 

In a Line Chart I use following 
Axis: Month Abreviation
Legend: Year

Values: CUMULATED KPI

CUMULATED KPI is a Measure:

CUMULATED KPI = CALCULATE( SUM(F_AMOUNTS[KPI Month]); FILTER( ALLSELECTED(F_AMOUNTS); F_AMOUNTS[MONTH] <= MAX(F_AMOUNTS[MONTH]) &&  F_AMOUNTS[GROUP] = MAX(F_AMOUNTS[GROUP]) &&  YEAR(F_AMOUNTS[MONTH]) = YEAR(MAX(F_AMOUNTS[MONTH])) ) )

 
Result:

 

But when I use a Line and Clustered Column Chart

Shared axis: Month Abreviation
Column series: Year

Column values: CUMULATED AMOUNT
Line values: CUMULATED KPI

I get this:

where I should expect this:

How is this possible? How can I get the expected result?

Thanks

R.W.

[Anonymous]

Hi @Anonymous,

Based on the test, I found the field that you used in 'columns series' not filter and interact with the fields you use in 'line values'.  So your measure expression with filters with the current year group not works and it displays the summary value instead.

For your scenario, I'd like to suggest you write multiple measures and use on 'line values' field.

Regards,
Xiaoxin Sheng

[Anonymous · Accepted solution]

Thanks @Anonymous,
ndeed that's what I have done for both the values as the KPIs

CUMULATED AMOUNT 2019 = CALCULATE ( SUM ( 'F_AMOUNTS'[AMOUNT] ); FILTER ( ALL ( F_AMOUNTS );
MONTH ( 'F_AMOUNTS'[MONTH] ) <= MONTH ( MAX ( 'F_AMOUNTS'[MONTH] ) ) && YEAR ('F_AMOUNTS'[MONTH] ) = 2019 && 'F_AMOUNTS'[GROUP] IN DISTINCT ( 'F_AMOUNTS'[GROUP] )))

CUMULATED AMOUNT 2020 = CALCULATE ( SUM ( 'F_AMOUNTS'[AMOUNT] ); FILTER ( ALL ( F_AMOUNTS );
MONTH ( 'F_AMOUNTS'[MONTH] ) <= MONTH ( MAX ( 'F_AMOUNTS'[MONTH] ) ) && YEAR ('F_AMOUNTS'[MONTH] ) = 2020 && 'F_AMOUNTS'[GROUP] IN DISTINCT ( 'F_AMOUNTS'[GROUP] )))

CUMULATED KPI 2019 = CALCULATE ( SUM ( 'F_AMOUNTS'[KPI Month] ); FILTER ( ALL ( F_AMOUNTS );
MONTH ( 'F_AMOUNTS'[MONTH] ) <= MONTH ( MAX ( 'F_AMOUNTS'[MONTH] ) ) && YEAR ('F_AMOUNTS'[MONTH] ) = 2019 && 'F_AMOUNTS'[GROUP] IN DISTINCT ( 'F_AMOUNTS'[GROUP] )))

CUMULATED KPI 2020 = CALCULATE ( SUM ( 'F_AMOUNTS'[KPI Month] ); FILTER ( ALL ( F_AMOUNTS );
MONTH ( 'F_AMOUNTS'[MONTH] ) <= MONTH ( MAX ( 'F_AMOUNTS'[MONTH] ) ) && YEAR ('F_AMOUNTS'[MONTH] ) = 2020 && 'F_AMOUNTS'[GROUP] IN DISTINCT ( 'F_AMOUNTS'[GROUP] )))

I removed the Column Series on Year

R.W.

[amitchandak]

@Anonymous , As of now clustered line visual does not split line based on legend. Means you will get only one line

You can create an idea - https://ideas.powerbi.com/ideas/

or check for any custom visual - https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals