Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

100% Stacked Column and line chart

Hi guys,
I am creating a 100% Stacked Column and line chart, like so :

GT = Var cat=CALCULATE([CT],ALLEXCEPT('DimDate',DimDate[Month]))
Return
DIVIDE([CT],cat)
 
But my y-axis is not 100% is 300%, any thoughts? 
 

 

  • Anonymous , Remove the filter of legend

     

    GT = Var cat=CALCULATE([CT],removefilters(Table[Legend Column]))
    Return
    DIVIDE([CT],cat)

2 Replies

  • Anonymous , Remove the filter of legend

     

    GT = Var cat=CALCULATE([CT],removefilters(Table[Legend Column]))
    Return
    DIVIDE([CT],cat)