Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello. i have a visual having data from differnt measures coming as column. now i want to have a line chart from it with multiple columns falling on x axis. currently i am exporting it csv and then re importing it and using transform->unipivot to make the multiple columns in one and using.. but i guess this should not be the correct way to do it and we should have a better way.
below is snapshot of the table. here i want the last 3 columns on the X axis, 1st Column as Legend and the values as values.
Hi,@sandeepganju
Can you please share pbix or some data sample and these three measure and expected output.
then we can try to find a better way.You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |