Ranked Slicer

[PHO]

Can I add a ranked slicer based on a Category?
I have a Table and a Bar Chart. 
1. In this Table the first Column are Categorys,
2. the Second  is Count of Numbers

3. the third is a measure from Count of Numbers to Use is in the Ranking: 

DocumentCount = COUNT('Data'[NUMBER])

4, the last one was my try to rank:

Rank =
RANKX(
FILTER(
'Data',
'Data'[Category] = EARLIER('Data'[Category])
),
'Data'[NUMBER],
,
ASC,
Dense
)

It is ascending but unfortunately not individual.

At the end I would like to be able to select the individual categories in the slicer. Something like a TopN slicer.
But I have Problems with it since there a lot of strings in the values.

[Anonymous · Accepted solution]

Hi @PHO ,

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Create the measures as below(it seems what you are trying to create is a calculated column to get the rank)

DocumentCount = CALCULATE(COUNT('Data'[NUMBER]),ALLEXCEPT('Data','Data'[Category]))

Rank = RANKX(ALLSELECTED(Data ), [DocumentCount],,DESC,Dense)

2. Create a table visual

If the above one can't help you get the solution, please provide the required info just as suggested by Ibendlin. Thank you.

How to provide sample data in the Power BI Forum

Best Regards

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...