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,
I have a visulization table with
Account, TER_FYTD_USD,
would like to diplay only top 10 accounts basis of TER_FYTD_USD value.
how do i achieve this?
Solved! Go to Solution.
Hi vjnvinod,
I'ts very simple.
In the visual level filter you have to select TopN as in the image below and drag the filed TER_FYTD_USD, in my case is count of nº r..., then select de number of top you want to visualice and select apply.
Please,
If you think that my answer is correct, mark it as accepted
The Top N Filter may not be available. If not, you will need to create a RANK of the value.
AAARANK = RANKX (
ALLSELECTED ( EnterTableName[Account] ),
CALCULATE ( SUM ( EnterTableName[TER_FYTD_USD] )))
This will assign 1 to the highest value so you can filter by the rank >= 10
Oh, if you want to sort by Rank you may need to bring the rank into the table. I hate it that the Sort by Column will not include measures.
Hi vjnvinod,
I'ts very simple.
In the visual level filter you have to select TopN as in the image below and drag the filed TER_FYTD_USD, in my case is count of nº r..., then select de number of top you want to visualice and select apply.
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |