Forum Discussion
Ranked Slicer
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:
RANKX(
FILTER(
'Data',
'Data'[Category] = EARLIER('Data'[Category])
),
'Data'[NUMBER],
,
ASC,
Dense
)
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.
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
2 Replies
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
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-Forum/ba-p/963216
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/1447523
