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, Anonymous
According to your description, I think you can easily create a measure, then use it in filter pane to filter data you want.
Like this:
Measure = RANKX(ALL('Table'),[Column3],MAX([Column3]),ASC)
If it doesn't solve the problem, Please feel free to ask me.
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
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.
thank you v-janeyg-msft .