Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table that gets distinct values from a date table in the order they'd go in a caledar (what I want). It looks like this
When I use Month & Year as Columns in the matrix, they appear in alphabetical order. How do I make it so that the order from the table carries down?
Solved! Go to Solution.
@Anonymous ,
Seems like the column is text type in your table so the matrix will sort the column by the first alphabet letter. You can click query editor and change the column type to date type like below then the matrix will be sorted by date.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
Seems like the column is text type in your table so the matrix will sort the column by the first alphabet letter. You can click query editor and change the column type to date type like below then the matrix will be sorted by date.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
If you don't have it already create a numerical column YearMonth in your date table (ex. 201901 for Jan-2019) and use trhat column in the Sort by Column option
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |