Forum Discussion

skitovich's avatar
skitovich
Helper I
6 years ago
Solved

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?

  • skitovich 

    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

1 Reply

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion

    skitovich 

    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