Forum Discussion
Dynamic change for Yaxis line graph and Matrix visual
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.
the workaround and solution you have provided is direct.
But in my requirement i dont want to do any transformation because i do have other columns which may get affected.
As you have taken same column in matrix visual, but in my scenario there will be different columns and value should appear w.r.t slicer and same thoing for Line chart as well
Hi ghouse_peer
Do any transformation may get some other columns affected.
But you know, power bi's calculations are column-based, and if you don't convert them, you might do a lot of redundant calculations and even fail to get the correct outcome most of the time.
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.