Forum Discussion
Capturing selected column
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
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.