Forum Discussion
Stacked column chart- X axis repeats
Hi, I was able to include a calendar table using DAX and convert calendar year to fiscal year in my visual. But, in one of the stacked column charts (A), the X axis shows repeats of the 12 months wi...
amitchandak
Super User
Super UserS_Balaji , In the first one you have all the columns expended, You can have three columns(from the date table) like a year, qtr, or month. Only expand one level and sort on the axis.
Hi Amit,
Thank you for your quick response. When I expand Chart B (the one format that I would like to have in chart A) further for months, it looks appropriately like below - with no 12 month repeats 4 times, one for each quarter (I realize this should have been the one I should have posted in my help request). Would appreciate any suggestions. Thanks