Forum Discussion

Janaya1's avatar
Janaya1
Frequent Visitor
2 years ago

Dynamic Line Chart with Wide Table

Hello,   I have a wide data table (1 row per unique ID and hundreds of numerical and text columns for each row) and I am trying to create line chart where the y-axis can change depending on slicer ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi @Janaya1 ,

According to your requirements, I create a table and a parameter.

Then I create a slicer and add the Batch Number in the slicer.

 

Finally we can select when we put Batch Number in x-axis and Measures in y-axis.

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Janaya1's avatar
    Janaya1
    Frequent Visitor
    2 years ago

    Sorry it took me awhile to respond, I was trying to get my company to update the Power BI version in the portal to be able to open the file you sent. That's not quite what I'm looking for. I want all of the "Batch Number" on the x-axis to be there, and I want the y-axis to show one variable at a time in a line chart and then I could select from a dropdown to change the y-axis variable. I can't seem to attach a file to my replies