Forum Discussion

NickMol25's avatar
NickMol25
Frequent Visitor
5 years ago
Solved

Dynamically display Column values based on RANKX formula.

I have created some formulas which ranks countries based on a value. I have one measure which shows the rank based on sales, and then a legend column which displays the country when the country is ra...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, NickMol25 

    Thank you for your feedback.

    I am not sure why that happened.

    Can you change your legend measure like below?

    Or, you can also refer to the link down below, that I just created some sample pbix file to test it.

     

    Legend = IF([Measure] <= 5, SELECTEDVALUE(Data[Country]), "Other")
     
     
     
     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.

NickMol25's avatar
NickMol25
Frequent Visitor
5 years ago

One additional question. In a measure everything works fine, but if I want to use this in a graph it would need to be a column. How can I make sure that this will also work? I tried the measure formula but the selectedvalue does not work over there. 

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, NickMol25 

You are correct, and you have to have some kind of grouping table.

For instance, TopNCustomers rank between 1~5, and OthersCustomers rank between 6~100.

Then, in this case, the graph can show the legend.

 

I hope this helps.

Thank you very much.