Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I have a bar chart with a date hierarchy on the axis and Sales-numbers as the values. When it's showing the default view (years on the axis) I have the possibility to add a trendline, as shown in the picture.
If I click the most right hierarchy-button (to get to a lower level), I get the exact view I want. But as shown in the second picture, there is no option here to show a trendline.
Am I doing something wrong here or is there a workaround to show a trendline on the second visual?
Also there are 65-ish bars and it's only showing like 50 or so. Is there a way to fix this as well?
Thank you very much
Solved! Go to Solution.
Do not use date hierarchy ,the trend line can be displayed normally by using the year, month and day of the date table.😮
Hi @Anonymous ,
I tried linking my date values of my primary table to those of my date table, Added a non-hierarchy Year and Month column. Unfortunately I still don't have the option to select a trendline.
you month is not a normal date format.
@Anonymous
Hi @Anonymous, I missed the part where i changed the format of my field to date...
Thank you for pointing this out!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
88 | |
82 | |
64 | |
49 |
User | Count |
---|---|
125 | |
111 | |
88 | |
69 | |
66 |