Line chart question

Hi marlline,

If you are using this calculated month year column you need to have this columns as number format.

The best in my opinion is to add the year and month on x-axis and then do the full drilldown that will concatenate the month and year

Regards,

MFelix

marlline 

When you create those calculated value such as a concatenation between month name and year you need to then sort it by a different field to get the correct order. So I would suggest you create a month number column and using this number sort your concatenated column this would then sort by month by year hence putting it into the right order.

Just in case you cant find the "Sort By Column"

Select the desired field you are going to sort and then within the Modelling tab you will see a Sort By Column and usin this you can select the column to be use to sort this target column. 

Hope this helps.