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.
I have a series of datasets which ranks salespeople by performance. The rank is not determined by through a calculation.
Within the table, I only want to display the rank of the Top 10, in order.
Need some help with a DAX statment so the table will be constrained to only show the Top 10.
Thanks!
Hi @irnm8dn
The rank is not determined by through a calculation.
If the rank column comes from the original data source and don't need to calculate to get this result, since you want to only show top10 rank in the table visual, you can add this column to the Visual Filter and select "is less than or equal to 10".
Then the table would only show top10 rank.
Best Regards
Maggie
That's an interesting application of a visual filter. What about if I specifically wanted to limit the data (with no risk of the user changing it)?
Hi
If possible, could you please share a sample data set with expected result ?
Thanks
Raj
@Anonymous
Please see this link for a sample file.
The PBI output will limit the table to show only the Top 10 by %.
Thanks!
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |