Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
Can someone help me with the following issue?
I have a report in PBI:
and in Excel I have:
I want to have the Excel-report also in PBI but I don't know what I have to do. I think I have to use a sort of supporting table:
but I don't know how. Can someone help me?
Thanks in advance,
Cor
hi, @Anonymous
Yes, you could get it by "Sort by column in Power BI Desktop".
Best Regards,
Lin
hi, @Anonymous
It is sort by column function. refer to these articles:
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
http://radacad.com/sort-by-column-in-power-bi
Best Regards,
Lin
@v-lili6-msft: I know where I can find the sort of the columns but unfortunately it's not the solution. It isn't gving me the result I want. 😞
hi, @Anonymous
I may have a misunderstanding on your case, Could you share your sample pbix file and your expected output.
Best Regards,
Lin
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |