Forum Discussion

PHO's avatar
PHO
Frequent Visitor
1 year ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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's avatar
lbendlin
Super User
1 year ago

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