The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello,
I have really huge dataset and I want to sort categories. I know the pattern is Category 1, Category 2 etc so Category N where N is a number. I want them sort them from Category1 up to last category. The number of categories might be changed due to refresh of the data (there could be more from each refresh) therefore creating new table with cat number and index is not feasible way (not to mention that there could be like hundreds of categories)
Is there any feasible way to do that?
@Pbiuserr , Usually we use +0 to measure or use the option show Item with no data. But they are more successful when you have separate dimension
Hi @amitchandak . I want them on slicer in that organized way. would it work as well?
@Pbiuserr , for that you need a sort column, Again you have to create a new column if you need , may be 2 two avoid circular dependency
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
This guy, luckily has categories in a good order from 1-5, however mines are like 118 and then 9 and then back to 100+ etc. I know how to sort dates but not how category which are text type but pattern is Category N (where N is a number)
@Pbiuserr , if you can have calculated column, I would split that in power query by space OR digits and non digits into a new column and would have used that as sort order
@amitchandak that was my first thing I've done - by M also by DAX, but in both scenarios I have circucal dependency. Thats why I am asking there in a thread if that is impossible
User | Count |
---|---|
56 | |
54 | |
53 | |
48 | |
30 |
User | Count |
---|---|
173 | |
89 | |
70 | |
46 | |
45 |