Select multi consecutive rows in Matrix Visual

Hi, Anonymous 

My previous method is suitable for matrix and measure, but it needs to be set for each visual. You didn't mention multiple viusal before, so I didn't consider it. 

For the questions you asked later, I have a workaround. 

Since you have other measures in the filterpane that will affect the filter results, you need to create a table first(from your measure).

Table 2 = filter(Summarize(Raw, Raw[Query], "_1", calculate(SUM(Raw[Impressions]),filter(Raw,Raw[Domian] ="domain0")), "_2", calculate(SUM(Raw[Impressions]), filter(Raw,Raw[Domian] ="domain1"))), not(isblank([_1])) && isblank([_2]))

Then 

1. Create a measure for rank.

Like this:

rank =
RANKX (
    FILTER ( ALL ( Raw ), [Query] IN DISTINCT ( 'Table 2'[Query] ) ),
    CALCULATE ( MAX ( Raw[Query] ) ),
    ,
    ASC,
    DENSE
)

2. Create a custom slicer based on the value of rank.

3. Create a measure in filter pane to filter data.(each visual)

Like this:

sort = IF([rank] in DISTINCT(Parameter[Parameter]),1,0)

Finally, you can use slicer to filter data you want.

Reference: Use what-if parameters to visualize variables - Power BI | Microsoft Docs

Best Regards

Janey Guo

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