Forum Discussion
Post PatronDynamic change for Yaxis line graph and Matrix visual
Hi Team,
I have a requirement.
In my model I have 1 table which has columns
| Gross A |
| Gross B |
| Gross C |
| Net A |
| Net B |
| Net C |
I want to take all these column names in 1 slicer.
Slicer wil have drop-down of all these columns name.
I have 2 visuals
1.Line Graph- X axis Date
2.Matrix Table wih diff columns
Now when a user selects Gross B from slicer Line Graph Yaxis should show Sum of Gross B
In Matrix visual normal values pertaining to Gross B should change.
Please help me with the solution.
Thanks in advance
6 Replies
Hi ghouse_peer
How the diff columns work in matrix? What is the structure of the table in which you store your data?
You know, it's hard to get the right outcome when you don't have enough data.
Please share your raw data(exclude sensitive data) or create some sample data, so that we can help you better.
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ghouse_peerHi Anonymous Ashish_Mathur
Gross A Gross B Gross C Net A Net B Net C 3.4 12.3 40.2 13.33 12.4 62.4 22.5 12.2 10 2.4 10.4 12.4 10.3 10 6.7 50 45 30 along with this i have date column in same table.
I have 2 visuals:
1. lin graph- Xaxis = Date; y=?
2. Matrix Visual- Date; Values=?
Now i want a slicer which should have a dropdown of all 6 column names:
Gross A
Gross B
Gross C
Net A
Net B
Net C
when a user selects Gross A , for line graph Y axis should show Sum of Gross A and Matrix Visual should show normal values as value which is available in table.
Likewise for Gross B, Gross C, Net A, Net B, Net C.
let me know any further information required.
Hi ghouse_peer
Please try this:
I add a date column for the reference.
Transform data > Select all the columns without date column > Transform > Unpivot Columns:
Close & Apply
Then add matrix and line chart:
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Ashish_Mathur
Super User
Hi,
Not sure of what you want to achieve but the initial thought i get is of restructing your data. You should use the "Unpivot Other Columns" feature in the Query Editor. To receive further help, describe the question, share some data to work with and show the expected result.
