Hello everybody. You do not know how to put the marking 40,41,42 and so on instead of 40, 42, 44?
Where are the values from the x-axis coming from?
You can make the axis sequential by setting it as "Continuous" under the x Axis formatting options:
And enable Show Items with no data:
This will give you this (I've included a combined bar chart and line chart to illustrate the problem of using a line chart visual: namely, the actual lines are misleading.
As an alternative, create a Dim table of your x-axis values with a continuous series using something like:
Ref series = GENERATESERIES(MIN(XAxis[Ref]); MAX(XAxis[Ref]); 1)
And set the model like this:
You can then use the field from the Dim Table as your x axis. Here are the same charts as above, but using the Dim Table field as the axis: (note the difference both line chart visuals; the one on the right is the actual true representation of the data since there are blank values in the dataset)
So it is up to you which you use of course. But depending on which visual you choose, you may be in effect inducing "wrong" insights
Where are the values from the x-axis coming from?
You can make the axis sequential by setting it as "Continuous" under the x Axis formatting options:
And enable Show Items with no data:
This will give you this (I've included a combined bar chart and line chart to illustrate the problem of using a line chart visual: namely, the actual lines are misleading.
As an alternative, create a Dim table of your x-axis values with a continuous series using something like:
Ref series = GENERATESERIES(MIN(XAxis[Ref]); MAX(XAxis[Ref]); 1)
And set the model like this:
You can then use the field from the Dim Table as your x axis. Here are the same charts as above, but using the Dim Table field as the axis: (note the difference both line chart visuals; the one on the right is the actual true representation of the data since there are blank values in the dataset)
So it is up to you which you use of course. But depending on which visual you choose, you may be in effect inducing "wrong" insights
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
