The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have data for each account code from 2016 till 2022 Dec on a monthly basis. I have used a line chart to graph this data and used the "Analytics" feature to forecast the values for 2022. What I am trying to see is how well the PBI has forecasted the fiures as I have the actuals for 2022.
I want to showcase this by:
a) Showing the actual (2022) figures against what PBI has forecasted for 2022 in the same line chart
and
b). Use a table to show the actual, forecast and the % varaince across the same line.
I am aware that PBI gives the opportunity to "show as a table" which gives me the opportunity to see the actual and the forecast in a table, but not in the same line.
What I want is something like shown in the screenshot. Kindly let me know how I could achive that.
Thank you
Loshini
User | Count |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
14 | |
14 | |
9 | |
7 |