Highlight a row in matrix when clicked on a cell value (metric name)

[andrelee]

Hi All,

I have a matrix on my dashboard, and I wonder if it is possible to highlight a row when clicking on the cell value.

The first column of the matrics holds the site names, the second column has the metric names, and the rest of the columns are metric values by date period.

Currently, if I click on a metric name, it highlights all the rows (entire section) related to a site.

I would like to click on a metric name, and it should highlight the row for that metric name.

Please advise. Thank you

[v-jianpeng-msft]

Hi, @andrelee 

This feature is still in voting, and if you really need it, then you open the link below and vote for it. When there are enough votes, the feature will go to the update list.
Your valuable input will facilitate the further development of Power BI.

Microsoft Idea

In order for other users to be able to quickly find this idea and vote for it when they are looking for a solution, you can mark it as a solution.

Best Regards

Jianpeng Li

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

[DataNinja777]

Hi @andrelee ,

My understanding is that Power BI does not natively support row-specific highlighting when clicking a cell in a matrix, unlike Qlik Sense, which allows direct interaction and selection within tables. In Power BI, clicking a cell applies cross-filtering or cross-highlighting, which affects all related data rather than just the row. However, a similar effect can be achieved using a combination of a slicer and conditional formatting.To simulate row highlighting, a slicer can be added for the Metric Name column. When a user selects a metric, conditional formatting can be applied to the matrix to highlight only the selected row. This requires creating a DAX measure that checks if the row's metric matches the selected value.

SelectedMetric = SELECTEDVALUE('Metrics'[Metric Name], "None")

HighlightRow = 
IF(
    MAX('Metrics'[Metric Name]) = [SelectedMetric], 
    1, 
    0
)

Once this measure is created, it can be used in the Conditional Formatting settings of the matrix visual. Selecting a column in the matrix (such as the metric values) and applying conditional formatting to the background color will highlight the row when the corresponding metric is selected in the slicer.If an interactive selection without a slicer is required, using Bookmarks and Buttons is another alternative. Bookmarks can be created for different metric selections, and buttons can be used to switch between highlighted views. Additionally, custom visuals like Deneb (Vega-Lite) or an HTML-based table can provide more advanced interactivity.While Qlik allows direct cell selection for row highlighting, Power BI requires a workaround. The closest alternative is to use a slicer and conditional formatting, which dynamically adjusts the row’s background color based on the selected metric.

Best regards,