Capturing selected column

Question

Hello,I have a Matrix visual in my report with multiple columns.&nbsp;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?&nbsp;

danextian · Answer

Hi&nbsp;sabeensp ,&nbsp;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 · Answer

danextianHow?

danextian · Answer

Hi&nbsp;sabeensp&nbsp;Try putting fields in a matrix visual and the same or different fields from the same or related table, this time, in&nbsp; 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.&nbsp;&nbsp;You can find more information about interaction between visuals here:How visuals cross-filter each other in a Power BI report&nbsp;Change how visuals interact in a Power BI report&nbsp;

sabeensp · Answer

danextian&nbsp;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&nbsp; 3 columns Toyota, Nissan, and Honda&nbsp;Next Steps: User wants to click or drill through Toyota and I want to plot All teh values under Toyota olumn in Line Chart.&nbsp;&nbsp;

Forum Discussion

Capturing selected column

4 Replies

Related content

Variance column for Dynamically selected columns

Single Selection of aggregated columns

select only one row from the column

capture slicer selection

Select Certain Row to Transform Into Column