Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have an excel with 3 columns (sample below)
1- for months
2- for years
3- sales value
Year | Months | Sales |
2019 | 8 | 15000 |
2020 | 2 | 4000 |
2020 | 3 | 2322 |
2020 | 9 | 53354 |
2019 | 2 | 2222 |
2021 | 1 | 233 |
2019 | 11 | 87764 |
2020 | 10 | 7565 |
2019 | 1 | 136935 |
2020 | 12 | 14785 |
2019 | 1 | 546 |
I am trying to build a line chart , in which each line represents the sales in a year.(desired outcome in the screenshoot below)
How I can do this?, do I need to use DAX expressions?
Thanks
Solved! Go to Solution.
@Karim_Hossam You can just use a line chart with the X axis as your months, legend as your year, and the sales as your values.
After you create that, check your x-axis and make sure the type is categorical (not continuous, as it may try as the months are numbers), and that you sort it by month, not sales value.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
@Karim_Hossam You can just use a line chart with the X axis as your months, legend as your year, and the sales as your values.
After you create that, check your x-axis and make sure the type is categorical (not continuous, as it may try as the months are numbers), and that you sort it by month, not sales value.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |