Forum Discussion

arlequin71's avatar
arlequin71
Helper II
7 years ago
Solved

Filter a visual based on ranked dimension

Hello, could you please advice me on how to proceed to filter a chart based on Customer Ranking?. As shown in the image i need the customer filter above each visual changes (and filter the visual) ac...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi arlequin71 ,

     

    Assuming that your ranking measure looks something like this:

    ranking = RANKX(ALL(Query1[Customer Name]);CALCULATE(SUM(Query1[Sales])))

    Just add the customer name to the legend (you can then hide the legend), and then add your ranking measure to the visual filter, for each one of the top for select ranking equal 1, 2, 3 and 4 and you should have the required result.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
7 years ago

Hi arlequin71 ,

 

Assuming that your ranking measure looks something like this:

ranking = RANKX(ALL(Query1[Customer Name]);CALCULATE(SUM(Query1[Sales])))

Just add the customer name to the legend (you can then hide the legend), and then add your ranking measure to the visual filter, for each one of the top for select ranking equal 1, 2, 3 and 4 and you should have the required result.

 

Regards,

MFelix

arlequin71's avatar
arlequin71
Helper II
7 years ago

It works, thanks MFelix 

Just wondering now how to implement the same solution in a Line and Clustered Column Chart.

 

Regards,

 

Alex-