Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
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.
it is a measure against a fiscal month-year field. I will see if i can replicate with an example.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |