Forum Discussion

majidht's avatar
majidht
Frequent Visitor
9 years ago

sort date

Hello guys, I am new to Power BI and I searched the forum but I didn't find the answer to my question so here we go... I am using power BI to connect to SSAS cube I made. When I use "connect live o...
Need Help
majidht's avatar
majidht
Frequent Visitor
9 years ago

Hello guys,

I am new to Power BI and I searched the forum but I didn't find the answer to my question so here we go...

I am using power BI to connect to SSAS cube I made. When I use "connect live option", I can see the time hierarchy, year, quarter and month with the proper sorting I created in visual studio. However, when I import the cube to Power BI, I see different sortings. For example, For month I see the members sorted alphabetically but I want it to be sorted by month number(Jan, Feb, Mar...). How do you think I can solve this problem?

 

Thank you,

Majid

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

majidht

 

Hi Majid,

 

As using "connect live option", maybe you could create a new column in the cube as Anonymous suggested. Here is a post I think is very helpful. How-to-order-mm-yy-format-based-on-months-and-not-in Add a new column with format "201701", then the order would be good.

 

 

Best Regards!

Dale