Forum Discussion

LarsPW's avatar
LarsPW
Frequent Visitor
3 years ago
Solved

Filtering table doesn't work

I have a table with years which I want to be able so sort year by year. But as you see when I trying to add filters to the table, One year apperas sevral times in the filter list, and the list ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi LarsPW ,

     

    It's recommended that you change the data type of the year column to whole number type first, and then sort it.

    Data types in Power BI Desktop - Power BI | Microsoft Learn

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.