Filter not applied in Visual however applied on datasource level

[Chaithanya6]

Hello All,

I am trying to filter the date by using the method creating datecode as datenumber+monthnumber. It is getting sorted in the Data level .

However it is not getting sorted in Visual level, however I have not added datecode in my visual but I have created mm-yyyy which is text format. datecode sorting in datalevel is not effecting in visual.

Please Help!!

[Anonymous · Accepted solution]

Hi @Chaithanya6 ,

Because in Power BI, will according to the ASCII code to sort the data in visual for string type field. Please try to sort the string type field by other column firstly, then add it to the visual.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Chaithanya6]

It worked thanks.. I was in assumption that it gets sorted automatically. I can removed the DateMM-YY from viz then sorted by datecode then added to viz, it worked. Thanks

[Greg_Deckler]

@Chaithanya6 Did you set a Sort By column?