cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anthonyx Frequent Visitor
Frequent Visitor

Preserving Order of Dimension from SSAS

Hi,

 

I'm connecting straight to Analysis services and in SSAS i've set up a dimension to order in a specific way showing actual before budget.

 

However in Power BI the it automatically sorts the dimension alphabetically. Is there anyway to get around this and use the sorting specified in SSAS or possibly re order the sorting in power bi.

 

Thanks in advance.

8 REPLIES 8
SivaMani Senior Member
Senior Member

Re: Preserving Order of Dimension from SSAS

@Anthonyx,

 

Yes, We can do the sorting.

 

We can do it at visual level

 

Sort.PNG

Anthonyx Frequent Visitor
Frequent Visitor

Re: Preserving Order of Dimension from SSAS

@SivaMani

 

I can see that but i'de like to sort it by version showing actual before budget however I cannot do this in the visual filter.

 

I am using a measure and version dimension to segregate the actual and budget.

 

PowerBI.PNG

SivaMani Senior Member
Senior Member

Re: Preserving Order of Dimension from SSAS

Got it.

 

Are you using live connection?

Anthonyx Frequent Visitor
Frequent Visitor

Re: Preserving Order of Dimension from SSAS

Yes a live SSAS connection.

SivaMani Senior Member
Senior Member

Re: Preserving Order of Dimension from SSAS

I think we couldn't do it in a live connection. It has some limitations.

 

We have also experienced the problem for the month. Fortunately, we had it on an axis so we simply sort it at a visual level.

SivaMani Senior Member
Senior Member

Re: Preserving Order of Dimension from SSAS

There is a workaround. You will calculate budget and actual as separate measures of Power BI.

 

Then add it to the visual in the order you want.

 

Hope It will help you!

guisin Frequent Visitor
Frequent Visitor

Re: Preserving Order of Dimension from SSAS

You need to use "Sort by Column" based on a numeric column in SSAS rather than using Sort by in PBI.

roxanar Occasional Visitor
Occasional Visitor

Re: Preserving Order of Dimension from SSAS

Create a month number under your date dimention If you don't have one .

Select your Monthname field and under properties ->Sort By Column then select the month number field.

That will do the trick

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 325 members 3,777 guests
Please welcome our newest community members: