Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
skitovich
Helper I
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.png

1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
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:

Format axis type.JPG

And enable Show Items with no data:

Inked2020-02-29 (1)_LI.jpg

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.

From Fact Table.JPG

 

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:

2020-02-29.png

 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)

From Dim table.JPG

 

 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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

1 REPLY 1
PaulDBrown
Community Champion
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:

Format axis type.JPG

And enable Show Items with no data:

Inked2020-02-29 (1)_LI.jpg

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.

From Fact Table.JPG

 

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:

2020-02-29.png

 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)

From Dim table.JPG

 

 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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.