Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
Hoping someone can help with this - which I think will be a simple fix that's not occurring to me as a newbie.
I have 3 seperate datasets consisting of:
1. Volumes for previous Fin. year (apr-17 - mar-18)
2. Forecast volumes for current fin year (apr-18 - mar-19)
3. Volumes for current fin year to doate (Currently April-18 only).
What I want is to add these values to a clustered column and line chart so that no.2 is listed as a line, with the other 2 as bars.
This is so as to compare current performance against expectations (forecast) and previous years performance.
The issues I'm having are as follows:
By creating a seperate date table in query editor I've managed to get the axis displaying the full range of 2 years (Apr-17 - Mar-19) but only the forecast item (2. above) is showing in the chart correctly.
Item 3. above is showing as one repeating value all acrosss year 18-19 rather than just assigned to April
Item 1. above is only appearing correctly if shown as either line or chart on it's own (wihtout 2 &/or 3) and if the matching Date dataset is applied.
I'm pretty sure this may have somethign to do with relations ships in the date-table buty would appreciate advise on the best method to achieve what I mentioned above.
Thanks in advance.
D
You may take a good look at this discussion.
http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373