Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |