Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
150 | |
118 | |
111 | |
106 | |
95 |