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.
I need to create a trend line on a bar chart that shows what the figures should be at that point in the year, So i have got the data off how many we should have in a year and in excel i would just divide by 12 and times by the current month to work out the profiled number for the year so far. How would i go about doing this in Power BI ?
@GregSibson , try this
choose clustor column chart add year on x axis and values on y axis . and go to visual choose x-axis change type to contineous.
after that go to search bar left to format by selecting cluster column chart and enable the trend line.
I hope this will work for you, if yes mark as a solution. Thanks
How do i actually get the data into power Bi though ? I have the data in an excel table but not sure how to put the figures into power bi to then link the trend line too ? So its not a trend line off the data over the year its what the figure should be at so in sales terms we have got 150 sales but at this point in the year we should have 200 and thats what i need to show on the line
Thanks for the video links doesnt fully answer the query still not sure how to get my own custom made trend line on the graph
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |