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

Anonymous's avatar
Anonymous
Not applicable
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