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,
I am banging my head on this one. I've researched so much I may have missed the solution. All I want to do is chart a line chart with 2 historical trend lines and then 2 basic linear trend lines for each of the 2 historical trend lines as show below. I realize that the x-axis has to be a date or number in order for a trend line to be available in the Analytics pane, but I cannot get to the point with what I have all tried.
The snapshot below shows how far I get, but you can see that the x-axis does not contain the quarter, it just contains the year. How I got to this point was by using DAX of Quarter = STARTOFQUARTER(Table[Date]).
Please, if anyone can help me out, it would be greatly appreciated!!!!
If you create a new date table using the code below, you can then use the YearQuarter column in the X axis. There are few other options to play around with in the table too.
@Chainfire74 - Thank you for responding with this option, however, I tried it out and I get the x-axis to read properly, but then I lose the ability to show a trend lines as you see here in my snapshot. The trend line option goes away cause the x axis switches to categorical (purple arrow). Any other thoughts? 🙄
@MattAllington - Hey Matt, saw that you are a MVP and just can't find a solution to my issue. Can you please take a look and see if you know how to help? I also just submitted a sample file of the data that I'm working with. Thank you!!!!
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |