Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi PowerBI People!
Some help needed please as I am going around in circles and reading so much on here I am losing the plot!
I have 2 data sources linked to one report - one showing all members who joined us over the past year, the other showing those who have left us over the year
I want to show number of joiners and the number of leavers in one line graph. Doesnt sound to difficult to me, but it simply wont play ball!
Now i appreciate this may be a quick fix for you lot, so feel free to point and laugh, but I cant see it for looking as my graph shows the monthly totals for one field [great!] but then the final total for the year for the other field [not so great!]
images show what i mean.
help. thank you. You are great!
Solved! Go to Solution.
hi, @Anonymous
There is a simple way for you to refer to:
Step1:
Use MONTH Function to create a Month column for these two data sources
Step2:
Create a month fact table
Step3:
Create the relationship between them by Month column
Step4:
Drag the field month form Month table into Axis
here is pbix, please try it.
Best Regards,
Lin
Hi,
Share the link from where i can download your PBI file.
hi, @Anonymous
There is a simple way for you to refer to:
Step1:
Use MONTH Function to create a Month column for these two data sources
Step2:
Create a month fact table
Step3:
Create the relationship between them by Month column
Step4:
Drag the field month form Month table into Axis
here is pbix, please try it.
Best Regards,
Lin
Hello again, thank you for this fix, I use it a lot and it is a great help, but every so often i lose track of the sorting option - it wont sort into MONTH.NAME order and i struggle to replicate this even copying the file you send through!?
How do i ensure that the month name is in date order and not alphabetical order?
Thank you
Hi ,
Create one Date dimension table.
link staff data on joining date with date table
link leavers data on leaving date with date table.
create 2 measures
joiners = countdistinct(staff table[emp id])
leavers = countdistinct(leavers[empl id])
Use 'Month' from Date table as axis and above 2 measure to plot the chart.
Hope this helps,
SS
My guess is that you are confusing the visual by putting two unrelated timelines on the x-axis. (Lapsed Month and Date of Joining Month). It's only slicing the data by one of them and ignoring the other.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |