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 ...
Need Help
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