cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

## help with markup

Hello everybody. You do not know how to put the marking 40,41,42 and so on instead of 40, 42, 44?

1 ACCEPTED SOLUTION
Community Champion

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

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Community Champion

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

In doing so, you are also helping me. Thank you!

Proud to be a Super User!