Forum Discussion
Sort by column based on another column for SSAS Tabular Source
Hi, I want to sort the month name based on month number using SSAS tabular source in power bi. I can see that sort by option in modeling tab is disabled. Is there any other way to sort the column or...
Hi guys,
I did sort by other column in SSAS in Date Table (Properties - [MonthName] sort by [MonthOfYear] ) and it also works in Power BI.
The Key is having data ready in SSAS model and no customization in Power BI so users can't change data onlz visualize them. ;)
Hi all, I'm experiencing a similar problem, but with a matrix visual. I have years in columns, but I want to show the most recent year first. I've tried sorting the data in the tabular model designer, but it's having no effect on the data in the visual.
Is there a way to manage this?