Forum Discussion

FredSilva's avatar
FredSilva
Frequent Visitor
6 years ago

Stacked Bar Chart not stacking correctly with Month-Year

Hi all,

 

I have found that if I use a Month-Year text field on my x-axis, the Stacker Bar Chart won't show me correct Stack/Sum. Though, if I change to a Month-Year numeric field it does show the expected SUM. Although using a Month-Year numeric shouldn't be too much of a problem, if I show more than one year the char has to go from 122018 all the way to 012019 which just looks silly...

 

Any tips on how to get around this?

 

Pictures showing the 3 cases are below, I have hidden the actual values but assume the  Month-Year text field give 1 order of magnitude less (as I attempted to should by the number of 0).

 

Thanks,

Fred

 

Month-Year Text - shows wrong Stack

Month-Year Text shows 1 order of magnitude less

Month-Year Num - Shows correct Stack

Month-Year Num for more than 1 year

Month-Year Num for more than 1 year

Need Help

2 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi FredSilva ,

    Do you put the same formula(calculate SUM) into the visuals? After testing, it works fine in my sample. Can you please share a simple dummy file to us? Then we will understand clearly and solve it quickly.  

    My sample

    Best Regards,

    Xue Ding

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

    • FredSilva's avatar
      FredSilva
      Frequent Visitor
      6 years ago

      Hi v-xuding-msft,

       

      Thank you very much for your answer. One difference I see betwee what you did and what I am doing, is that I am actually DISCTINCTCOUNT(transaction_id), instead of summing Sales.

      I do notice that if I change the chart with Year-Date Text to a Line and Stacked, the Line will show the right COUNT but the Bar are still wrong.

       

      Unfortunately making a sample out of this is not very straightforward, could we arrange for a support call instead? If yes please send me a Direct Message, otherwise I would need to spend the time to do a sample...

       

      Thanks,

      Fred