Help with Line and stack column chart

[rashel2002]

Hi all!

i created this chart (more detailed than it's shown here)-

and i want that after the first time we've got the max value, we won't have it again. what i mean is that i want it to look something like that-

 

is it possible to do so?

Thanks.

[Greg_Deckler]

You could create a custom column that you would then use as a filter or as a filter for a measure, something like:

Column = 
VAR __Max = MAXX(ALL('Table'),[No. of hours])
VAR __MaxWW = LOOKUPVALUE(ALL('Table'[WW]),'Table'[No. of hours],__Max)
RETURN
IF([WW]<__MaxWW,1,0)

[rashel2002]

Hi Greg,

thank you for your answer but It doesn't work 😕

the "No. of hours" column is unnecessary, the chart i created is based on the "**bleep** hours" column which is created by measure. maybe this is the reason the code you wrote isn't working to me 😕

what i want is to create new column/measure, based on that measure (on "**bleep** hours" column), and changing evey row that is the max value to zero, except to the first time.

is it possile to do it?

thanks again! 

[Greg_Deckler]

Hilarious "***bleep*** hours!!

One thing I do not understand, why is your cumulative total 7 when you have 2 hours one week and 7 another week?

[rashel2002]

hahaha oops! it should be 9 instead of 7! sorry about it