Values not aggregating to Month Year field in bar chart

[tbyberg]

In my Date dimension, i have a Monty Year field formatted:     mmm-yyyy

when i plop in onto an axis against an amount, the month year values are repeating instead of aggregating to one bar for each.

This is an Azure Analysis Services data source.

[tbyberg · Accepted solution]

I did find what i believe causes this issue.

In AAS, I had the default sort order for the fiscal month year field set to the Date.

If you do that, then it appears it is repeating the fiscal month year in the x-axis for each Day.  

I created a YYYYMM column to use in the default sort order for the fiscal month year, and now it is working as expected.

[rajulshah]

Hello @tbyberg,

Can you tell me if you are plotting a column or a measure? Also, it would be better if you can provide sample file for this.

Thanks.

[tbyberg]

it is a measure against a fiscal month-year field.  I will see if i can replicate with an example.

[Icey]

Hi @tbyberg ,

Looking forward to one example.

Best Regards,

Icey