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 All,
I hope you can put some light into my problem.
I have a Profit&Loss with Parent-Child hierarchy with 4 levels and everything works fine except one tiny detail. When I have all my data in the matrix, expanded all the way down all the account names are in the alphabetical order instead of the order I want them to be (see dummy example below).
In my Parent-Child hierarchy with all the DAX codes etc, I have an index column, and tried to sort the Child columns by that index however it does not work.
I wonder if anyone had similar issue? Any help will be highly appreciated. Thank you.
Solved! Go to Solution.
@sylwestercz,
I am afraid that it is not possible to sort the level4. A workaround is to add number(1,2,3) before these values as below.
Regards,
Lydia
can you please let me this task possible in power bi or not
input file structure
output requirement
@v-yuezhe-msft please help me out with your solution
@sylwestercz,
How do you store these data in your table? Could you please post the structure of your table with the Index column? And also please post the error message you get when sorting columns.
Regards,
Lydia
Hi Lydia @v-yuezhe-msft
Please see below how my hierarchy looks like.
In the Matrix visual I put Hierarchy (Level1 & Level2 & Level3 & Level4) as Rows and a measure as Values. The thing is that all hierarchy levels are presented alphabetically and I would like to find a way to make their appeareance in the Matrix as per AccountKey.
If instead of Hierarchy I put just AccountName in Rows, then everything is listed as per AccountKey however then I do not have the Parent-Child hierarchy, just the lowest level Account with corresponding value. In other words, Contribution Margin, Primary Costs, Salary, Other Costs are not presented in the Matrix.
The more I look into this the more I get the feeling it will not be possible...
@sylwestercz,
I am afraid that it is not possible to sort the level4. A workaround is to add number(1,2,3) before these values as below.
Regards,
Lydia
And that is exactly what I did now for Level 3 and will to the same for Level 4, perhaps with letters like a) b) c) .... but that requires changing (or adding lookup column) in the main source with all AccountName(s) so the relationship will follow along the chain.
Hopefully this will be recognized by Microsoft and (if there is a way) fixed or improved in the future.
Thank you Lydia!
Have a great day and Merry Christmas!
Sylwester
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |