Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good afternoon everyone,
I wanted to ask a quick question about finding the top N and others in PowerBI.
I followed the tutorial below from SQL BI originally, and the Ranking measure worked fine with the addition of a Top N parameter, and a lookup table so "others" could be included in my model.
Original Video:
https://www.sqlbi.com/articles/filtering-the-top-products-alongside-the-other-products-in-power-bi/
However, the problem came across when trying to include date in the columns, when I added in date to the columns of my top N visual the ranking itself broke. Due to organizational policies at my company I can't share the file I worked off of, but I will show my measures, and a sample case of the issue.
Solved! Go to Solution.
Good afternoon everyone, going to close out this forum post with the code that I used that worked for the case I was working with; turns out a simpler approach was the best way to resolve this issue.
Good afternoon everyone, going to close out this forum post with the code that I used that worked for the case I was working with; turns out a simpler approach was the best way to resolve this issue.
Hi, @sleopol ;
Thanks for sharing the file, I've opened the file, but I'm still not clear, what do you want to output, I've seen that your pbix has implemented dynamic topn; Sorry for not having a clear understanding of your specific needs.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Good morning, and thank you for taking a look at the file I uploaded. The issue I'm facing is that my ranking won't display the way the sample file will. In my first screenshot I showed how it's ranking incorrectly despite having the same measures as the attached file. For some reason it will not rank the top N lines per each category in my actual report, but rather seems to rank at random. I can't seem to find a difference in the measures I have posted above in comparison to the sample file I have shared either. Thanks again for the quick replies!
Good morning,
Please find attached an example of what I'm looking for.
My model has the same format for the data model with the exception of using date as a slicer for last 6-months.
Could having more lines that fall into multiple categories potentially affect my model?
In the attached example I did notice that each category only has unique products.
All of my measures are based on the attached PBI file on my one drive.
Thanks again for agreeing to look into this! I really appreciate it, and I've been stuck on this issue for a week or two now.
https://1drv.ms/u/s!AmLKI1g9O_1ok3hayWPBUg2P8amQ?e=PwF8kj
Hi, @sleopol ;
Sorry you shared too much, I looked a bit confusing and difficult to reproduce your model, due to the sensitivity of your data, can you create some data similar to your model, using a small example and the desired output, it is easier to understand and solve your problem.
please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
Solved: How to upload PBI in Community - Microsoft Power BI Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |