Forum Discussion

rashel2002's avatar
rashel2002
Helper II
8 years ago

Help with Line and stack column chart

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.

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    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's avatar
      rashel2002
      Helper II
      8 years ago

      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's avatar
        Greg_Deckler
        Community Champion
        8 years ago

        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?