cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Sorting of Month Name when Power BI is connected to SSAS

Hi,

 

We need to apply sorting in power bi reports for month name eg : Jan , Feb , Mar etc

 

There is MonthWid Column (Integer) which has the sorting order

 

Power BI is connected to SSAS(Tabular Model)

 

We have sorted the column month name on basis of month wid in SSAS and it shows correctly in SSAS

But it is not reflecting in POwer BI Reports..Has anyone faced same issue?

 

Is there something wrong? Any suggestions pls

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper V
Helper V

Re: Sorting of Month Name when Power BI is connected to SSAS

Hi,

 

Thanks All for the support !

 

It was not correctly done in SSAS , hence it was not reflecting in Power BI.

 

Its resolved now .

View solution in original post

7 REPLIES 7
Highlighted
Super User VI
Super User VI

Re: Sorting of Month Name when Power BI is connected to SSAS

Hi @GuestUser 

try to use Sort By Column technique.

see Section "Sort using the Sort by Column button" here https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-butto... 

 

do not hesitate to give a kudo to useful posts and mark solutions as solution


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Highlighted
Super User IV
Super User IV

Re: Sorting of Month Name when Power BI is connected to SSAS

Hi @GuestUser ,

 

that should work. (Check the order setting of the visual)

Can you post some screenshots?

- SSAS Tabular settings

- Power BI Report sample.

 

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

Highlighted
Community Support
Community Support

Re: Sorting of Month Name when Power BI is connected to SSAS

Hi @GuestUser ,

 

What  the kind of visual you are using with the Month column? Have you tried to change the Sort by dense order or ascen order?

 

1.jpg

 


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super User IV
Super User IV

Re: Sorting of Month Name when Power BI is connected to SSAS

Hi @GuestUser ,


is your problem solved?

 

If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

Highlighted
Solution Sage
Solution Sage

Re: Sorting of Month Name when Power BI is connected to SSAS

You have a few options. You can use the RANKX function outlined here: https://docs.microsoft.com/en-us/dax/rankx-function-dax

 

My prefered solution is to create a column with the month number (sometimes I do this in a referenced query to create a separate calendar table) and then do as the others here suggested and and set the month name column to sort by the month number column in the query editor.

Highlighted
Helper V
Helper V

Re: Sorting of Month Name when Power BI is connected to SSAS

Hi,

 

Thanks All for the support !

 

It was not correctly done in SSAS , hence it was not reflecting in Power BI.

 

Its resolved now .

View solution in original post

Highlighted
Super User IV
Super User IV

Re: Sorting of Month Name when Power BI is connected to SSAS

Hi @GuestUser,


If your question is answered, please mark a post as solution, this will also help others.
Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors