Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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:
Proud to be a Super User!
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
Proud to be a Super User!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |