Line and stacked column chart, prevent columns from continuous if data are same

[kala2]

I have a stacked line column chart:

Is it possible to remove the repeating columns if values are the same?

Expected Senario:

[v-jayw-msft]

Hi @kala2 ,

Create a measure like below and add it to visual filter.

Measure = 
var _max = CALCULATE(MAX('Table'[sales]),ALLSELECTED('Table'))
var _year = CALCULATE(MIN('Table'[year]),FILTER(ALLSELECTED('Table'),'Table'[sales]=_max))
var _month = CALCULATE(MIN('Table'[month]),FILTER(ALLSELECTED('Table'),'Table'[sales]=_max))
return
IF(SELECTEDVALUE('Table'[year])>=_year&&SELECTEDVALUE('Table'[month])>_month,0,1)

Best Regards,

Jay

[v-jayw-msft]

Hi @kala2 ,

The information was not clear enough.

Are you want to remove all repeating columns or the repeating columns at the end of visual.

For example:

jan 10

feb 10

mar 20

apr 20

Result1:

jan 10

feb 10

mar 20

Result2:

jan 10

mar 20

Are you want result1 or result2?

Best Regards,

Jay

[kala2]

Hi @v-jayw-msft, Thanks for the info,

My running total works until april 23. 

The problem is that i dont have values for may 23 so the chart continues until the end 

If you look in my example

And then with the measure applied January - April is missing

[v-jayw-msft]

Hi @kala2 ,

So you have repeated columns not just at the end of the visual and you want remove all repeated columns?

The two screenshots you showed above are different.

Best Regards,

Jay

[kala2]

hi @v-jayw-msft ,

I want to remove all the repeating columns at the end of visual.