Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello knowledgeable ones.
I’m trying to create a data model that can be used to compare multiple years on a line chart. With a line for hours of each activity, that can be filtered/sliced to show all years or just one at a time. And another line chart for hours of activity by day of week for the same.
Thanks for any ideas
Here's a sample of the data I'm working with:
https://drive.google.com/drive/folders/1JzcPmlL7egqLzsbJz72tMW0mRpdh0nD-
Solved! Go to Solution.
Go to Date table, select month name column then sort by "Month Sort"
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @Sean2
I did some cleaning and transforming on your model. and I got this
I am not sure where do you get the Tables (2018,2019....) from but you need delete un necessary columns from them and append them. Then add column for number of
Hours = DATEDIFF('Append Tables'[In],'Append Tables'[Out],HOUR)
and another column for the
Year Activity = YEAR('Append Tables'[In]) (by th way I chose dates IN, you pick what you want)
that don't make sense and need attention.
Last thing: I uploaded the Pbix file that I corrected to your drive.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thanks Amine! That helps a great deal and I think I'm on the right track to what we need. You are right there are some problems with the data integrity in this sample and I will need to correct them.
The visual I'm looking to get would be like the area chart at the bottom, but show January through December and if multiple years were selected it would compare the hours of each year.
Do you have any ideas how that could be acomplished?
Thanks!
Hi @Sean2
Not sure I understood, is this what you want to see
For years
Months
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Amine,
Yeah esentially like either one of those last two screen shots. Showing each month in chronological order. I've got close to what I'm looking for, but the months always show up in alphabetical order instead of chronological order.
Go to Date table, select month name column then sort by "Month Sort"
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |