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.
I believe this may have been covered before, however I did not find a complete solution for this issue.
The issue relates to having text as an X-Axis on a Stacked Area Chart, this is only apparent in the stacked area chart, I cannot replicate the issue with a Line or normal Area Chart.
For Instance:
Above shows the same data split between a Line and Stacked Area Graph, the Line chart shows the Data Labels in the correct position, however the Stacked Area Chart moves them to the left and there is no option to change this. I understand this is related to having Text as a primary X-Axis, as when I use a number I get the following:
The X-Axis here uses just numbers to represent the calendar year, however we utilise both Calendar and Financial Year in our tabular model, so we need to be able to prefix the number to show the end user which calendar is being used.
I can replicate the issue using a number X-Axis by changing the Type from Continuous to Categorical:
However I cannot select "Continuous" when I have the Financial Year selected as the X-Axis? It will always go back to "Categorical".
This may well be by design, however I just do not know why I have different default labelling behaviour between a Line and Area to a Stacked Area?
This is using Power BI Desktop for Report Server
Version: 2.61.5192.641 64-bit (August 2018)
Our normal reports connect live to a SSAS tabular model, however I could replicate the issues with a simple data entered model, which I am happy to share if needed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.