Forum Discussion

Chaithanya6's avatar
Chaithanya6
Regular Visitor
3 years ago
Solved

Filter not applied in Visual however applied on datasource level

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 Visu...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
Chaithanya6
Regular Visitor
3 years ago

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