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 Community,
Assist me in implementation of Trend Line to below visual.
IMAGE 1:
X Axis is Months from Jan 2017 to Dec 2017 , then Jan 2018 to Dec 2018, Jan 2019 to July 2017.
1. X Axis Type is Categorical now. In Categorical Type, Trend line in Analytical pane is not visible.
2. When X- Axis Type is changed to Continous, Trend line in Analytical pane is visible but X-Axis now becomes continous automactically Showing all values from 201701 to 201907 as below.
IMAGE 2:
But, X-Axis must not be like this because there is no meaningful in showing 201713, 201714, etc,..... (Because there is no month 13, 14)
Help in applying Trend Line to IMAGE 1.
Thanks in advance,
Sowmiya.
Solved! Go to Solution.
Hello @Sowmiya
Take a look at this solution from @OwenAuger
https://community.powerbi.com/t5/Desktop/DAX-to-create-a-Trend-line/td-p/398438
And this article discussing the same solution.
Hello @Sowmiya
Take a look at this solution from @OwenAuger
https://community.powerbi.com/t5/Desktop/DAX-to-create-a-Trend-line/td-p/398438
And this article discussing the same solution.
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |