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.
Hi Gurus
I am connected to SSAS (Live Connection) and created a matrix that has Year as column. I want to show the latest year from left to right (For example, from 2022 to 2020). I know that I need to do the changes at cube level and need help in knowing how to do it. Also that year column is being used in 10 other reports. The sort order for year column should not change for those reports.
PP
Solved! Go to Solution.
I created a sort order column with formula =- (Year) and then sorted year according to that new sort.
I created a sort order column with formula =- (Year) and then sorted year according to that new sort.
Hi @PBIDEV_10
If you only want to sort this visual, select that visual then cilck on More action. Link.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |