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,
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.
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
You need to use "Sort by Column" based on a numeric column in SSAS rather than using Sort by in PBI.
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.
Got it.
Are you using live connection?
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.
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!
Yes a live SSAS connection.
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 |
---|---|
97 | |
97 | |
82 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |