Forum Discussion
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.
Hi v-janeyg-msft , sorry I need to un-mark your reply as solution.
Reason:
I just checked the PBI file, your solution is working on a Table, but not matrix visual.
The expect result is:
if there is a way I can select consecutive items in a matrix visual.
As you can see, top 4 items are selected in Matrix Visual 1, so that in Matrix Visual 2 only 4 Query and their Pages are displayed.
I hope to have your further help.
Thank you in advance and have a safe day!
H
Community SupportHi, 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.