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.
Hello everybody. You do not know how to put the marking 40,41,42 and so on instead of 40, 42, 44?
Solved! Go to Solution.
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
Proud to be a Super User!
Paul on Linkedin.
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
Proud to be a Super User!
Paul on Linkedin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |