Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Dear Experts,
Below is the excel version, I try to develop this type of line charts on BI Desktop based on below data but cant be succeeded, please kindly guide me how to do this. I try my bast and many attempts but can't succeeded. Thank You.
Solved! Go to Solution.
First open Power query editor >> click trandform tab >> select year column >> click on "Unpivot other columns".
then click on close and apply, Now in power BI desktop plot line visuals and put months on X-axis, facts value on Y-axis and year in legends.
Please mark my solution as accepted if it works for you.
First open Power query editor >> click trandform tab >> select year column >> click on "Unpivot other columns".
then click on close and apply, Now in power BI desktop plot line visuals and put months on X-axis, facts value on Y-axis and year in legends.
Please mark my solution as accepted if it works for you.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 134 | |
| 96 | |
| 78 | |
| 67 | |
| 65 |