Combine two clustered charts

Not having any luck finding help on this one but I can't be the first to ask. I have two visuals that I'd like to have in one. I have a Date Table, and I have another CSV data source with labor hours...

Need Help

Anonymous
4 years ago
Hi Sean2 ,

1.Did you apply some filters like Year=2020/ Year=2021 to get such output ?

2. If your data from CSV file has Date column, and you have used it for X-axis, could you please drag Date.Year to Legend field to get values by different years?

3. And what is the Date table used for? Is there ny relationship between these two tables?

4. Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak

Super User

4 years ago

Sean2 , Create measure for this year and last year and use in same visual

create a date table join on date, have year and month in date table

Option one Year as legend , Month on axis and measure on values

In case you need measure , then for last year use measure like

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA

Sean2

Helper I

4 years ago

Thanks amitchandak. Thanks helps some, but I'm wanting a measure for specific years. Not relative to current year.

Is there a way to make that kind of measuer for 2019, 2020, 2021, ect?

Forum Discussion

Combine two clustered charts