Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
i am trying to graph the below. i just want each year as a line showing the values for the item number 23670030 by month.
i can achieve the below in excel.. each series is a year.. sorry rushed it 🙂
but the best i can achieve in power bi so far is..
any help will greatly appreciated.
Robert
Solved! Go to Solution.
Hi @eagletro,
According to your description above, you may need to use Unpivot option under Query Editor > Transform to unpivot your "JAN", "FEB" ... "DEC" columns to a column with all months, and a column with all values of each month.
Then you should be able to use the unpivoted Month column as Axis, the YEAR column as Legend, and the Value column as Values on the Line chart to get your expected result.
For more details about how use Unpivot option with Power BI, you can refer to this article.
Regards
Hi @eagletro,
According to your description above, you may need to use Unpivot option under Query Editor > Transform to unpivot your "JAN", "FEB" ... "DEC" columns to a column with all months, and a column with all values of each month.
Then you should be able to use the unpivoted Month column as Axis, the YEAR column as Legend, and the Value column as Values on the Line chart to get your expected result.
For more details about how use Unpivot option with Power BI, you can refer to this article.
Regards
Hello,
What about Year in Legend, Month in Axis and the measure in Values as in the following screen:
Thanks,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |