Sorting bar chart

[mario-sarkis]

hey all

my question is i have a bar chart with dimenssion monthyear but this field has dates since 2014

i need to show the dates on bar chart starting first of 2016 this means jan2016 and feb 2016 march2016

i formated the dimension as>> if(year>=2016,monthyear) ..this shows me feb2016 and jan2016 but as a descending feb the jan sorting even if i fix it on the sort tab on the chart ...i want to show ot as jan then feb .

hope anyone can help

‌

[marcus_sommer]

It's quite the same like this here: Chart sorting

- Marcus

[MK_QSL]

Go to sort tab.

Select monthyear and tick Expression

Write below expression

IF(monthyear >= YearStart(Today()),0,1)

Tick Numeric Value Ascending