Forum Discussion

Tanaka's avatar
Tanaka
Frequent Visitor
4 years ago

Each month total value tooltip for stacked bar chart

Hello, 

I'm trying to show each month total value in a tooltip, already tried to disable 'keep all filters' and use Date field in it, doesn't work as intended.

When hover in the last month, it's shows as intended, but when hovering others months the value stays the same.

 


I want to show the total of each month, not just the full total.

I'm using the following measure for values.

CALCULATE (
              Sum( Table1[sells] ),
              FILTER (
                         ALLEXCEPT( Table1, Table1,[plans] ),
                        Table1[Date]<= MAX ( Table1[Date])
               )
)

Axis = Date 
Legend = Plans

Any ideas? 

Regards.



 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    You remove all filters except the plans.  That means you are also removing the month filter.  That's probably not what you wanted.  Put the month filter back in (add it to the ALLEXCEPT list)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Tanaka ,

     

    Does the replies above solve your problem?

    If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

     

     

    Hope it helps,


    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.