How do I know I have a scalar data type? Can I change it to a scalar data type?

[MarkD1722]

I am trying to get the chart below to be a fixed width such that the columns will get smaller with each new set of data added to the data table, and then I can get rid of the slider/scroll bar for the x-axis.  I do not have that option available (like I do in another chart elsewhere).  In order to have that option, I need to switch the scale from categorical to continuous.  But, I need to have a scalar data type to have the option.  How do I change my data type to a "scalar" one?  The current data is from a measure.  I have another combination line and stacked column chart that does this perfectly (mentioned this earlier), but I don't understand the difference(s) between the two data sets to know what to do with this "non-scalar" one.

Thanks in advance for any insights and help you can provide.

[lbendlin]

Auto Date Time hierarchies should not be used beyond beginner level.  Use the Date field and let the visuals do the hierarchy for you.  Use a Calendar table in your data model.

[NaveenGandhi · Accepted solution]

Hi @MarkD1722 

Just change the date hierarchy to date using as per the below screenshot, Then you will have the x axis type option enabled.

As far as the scalar value, Anything that comes from a measure(a single number instead of a column of values) is a scalar value, Having date hierarchy might be considered non scalar. Not exactly sure about it though.


let me know if this helps 

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

[MarkD1722]

That's it!   Thank you.  I understand that now...that hierachy must put the data in an array format... which is not scalar.  Does that make sense?