How to show the top 10 as a changeable bar chart without slicer

[KayCon]

Hi All

I hope you can help I am trying to display the top 10 reasons for cancellation which I have done using the Top N within the filters for the visual.

However I also have a table displaying the locations and would like the visual top 10 reasons to change accordinly when a location is selected. The Bar chart count changes but the reasons for cancelling remains at the top 10 overall and not by location. 

Is there a way for the Y axsis to change according to the top 10 of the location selected within the table?

I know I can do this via a slicer but wanted to know if there was a way I can do this via the table selection?

Thanks

[powerbi2srm]

I don't know your tables, but firstly you've to create a measure for number of cancellations (for example) and then try with something similar to this:

Top 10 cancellation reasons =

VAR ranking =

RANKX(

    ALL('dim_reasons_cancellation'[name]),

    [num_cancellation],

    [num_cancellation],

    DESC,

    Dense

)

VAR top10 =

IF(

    ranking<=10,

    [num_cancellation],

    BLANK()

)

RETURN top10

In that measure, firstly you are creating a ranking based on number of cancellations. In the second variable, if the cancellation is among the top 10, the result will be printed.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.