Capturing selected column

[sabeensp]

Hello,

I have a Matrix visual in my report with multiple columns.

User requirement is, when users click on the column heading values get ploted on the line chart. So when users click on COLA, values are plotted in Linechart. Is it possible?

[danextian]

Hi @sabeensp ,

It should be possible in most cases as long as you don't disable the visual interaction between your matrix and line chart. Please see image below:

[sabeensp]

@danextianHow?

[danextian]

Hi @sabeensp 
Try putting fields in a matrix visual and the same or different fields from the same or related table, this time, in  a line chart.

If you click on the the cell/column/row in the matrix visual like in my screenshot, the line chart should also update. 

You can find more information about interaction between visuals here:
How visuals cross-filter each other in a Power BI report 

Change how visuals interact in a Power BI report 

[sabeensp]

@danextian 

Fileds in Matrix visual dynamically change based on slicer value selected. Example:

User Selects America from the slicer and Matrix will show 2 columns such as GM and Ford.

User Selects Japan from the slicer and Matrix will show  3 columns Toyota, Nissan, and Honda

Next Steps: User wants to click or drill through Toyota and I want to plot All teh values under Toyota olumn in Line Chart.