Forum Discussion
LarsPW
3 years agoFrequent Visitor
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 ...
- Anonymous3 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.
Anonymous
3 years agoNot applicable
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.