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, Everyone,
I developed a cube in SSAS.
When I connect through Power BI desktop, the MonthName column is not sorted.
When I connect to other data sources, I go to the DATA tab and I can sort.
How do I sort the MonthName column when my data source is SSAS.
For exemplo: January - February- March - April - May................................. December
Thank you.
_Keny
Solved! Go to Solution.
You need to do it at SSAS Level,
-You need to create a MonthNumber in your date dimension
- Then you need to change MonthName properties like this
Key column will be monthnumber
and Name & Value Column will be Month Name
- And 2nd Property that you need to change is OrderBy to "Key"
Redeploy the solution and your Month Name will be sorted.
Proud to be a Super User!
You need to do it at SSAS Level,
-You need to create a MonthNumber in your date dimension
- Then you need to change MonthName properties like this
Key column will be monthnumber
and Name & Value Column will be Month Name
- And 2nd Property that you need to change is OrderBy to "Key"
Redeploy the solution and your Month Name will be sorted.
Proud to be a Super User!
@kenymaciel , here you need a sort column for that.
refer: https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Hi,
I've tried it this way, it doesn't order the right way.
Month names are not ordered.
Thank you.
Hi , @kenymaciel
There is a workaround but not applicable to all visualization.
You can create a measure and apply it to the visual, and sort according to the visual.
Ex:
Measure = SWITCH(SELECTEDVALUE(DimDate[EnglishMonthName]),"January",1,"February",2,"March",3,"April",4,"May",5,"June",6,"July",7,"August",8,"September",9,"October",10,"November",11,"December",12,BLANK())
In table,matrix..( you need drag measure to "values"),you can sort by this measure in visual "more option"
If you want to hide the cloumn "measure" in visual, you can also directly shorten the width of the column "measure "to 0
In Line Chart,Bar Chart,Pie Chart .....(you can drag measure to "tooltip" ), you can sort by this measure
Best Regards,
Community Support Team _ Eason
If this post helps, then 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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |