Y axis label, why only even values

[SandroRiz]

I have a series of data that goes from 2013 to 2021.

Would be possible to have the Y label each every year and not by step of two?

Moreover, leaving Start and End to Auto, there are two useless spaces for 2012 and 2022 where I don't have data.

Forcing Start&End with right value, it eliminates that spaces but result is either ugly... Is there a setting like Density of Data Label (with 100% should plot every year)

Thanks in advance

[SandroRiz · Accepted solution]

I had already tried... it writes all the labels (and the behaviour in Continuous mode is even weirder because that means there is the space to write), but I don't like the sort order that I want chronological

[v-yiruan-msft]

Hi @SandroRiz ,

Please navigate to Format pane and find Y axis tab to set Type as "Categorical" and check whether it can work.

Best Regards

[SandroRiz · Accepted solution]

I had already tried... it writes all the labels (and the behaviour in Continuous mode is even weirder because that means there is the space to write), but I don't like the sort order that I want chronological

[v-yiruan-msft · Accepted solution]

Hi @SandroRiz ,

Please click More options (...) menu in the upper right corner of the bar chart, select Sort by, and then select Year field just like below screenshot.

Best Regards

[SandroRiz]

Perfect solution, thanks!

[Anonymous]

Hi @SandroRiz 

Make sure that the date table has the min and max date of your fact table. i.e. calendar(min(date),max(date)

Post that, try and reduce the size of y axis,make a calculated year column in your dim table of year and try if that works.

[SandroRiz]

my date table is shaped  right.
Growing (a lot) the height of the visual all the values are coming, but even in my size there would be space to render all...

MyCalendar =

ADDCOLUMNS (

CALENDAR (DATE(2013,1,1), DATE(2021,12,31)),

"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),

"Year", YEAR ( [Date] ),

"Monthnumber", FORMAT ( [Date], "MM" ),

"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),

"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),

...