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:
Solved! Go to Solution.
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.
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?
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.
Check out the News & Announcements to learn more.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.