Forum Discussion
Helper ICombine two clustered charts
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.
Super UserHi,
Ensure there is a relationship from the Date column of your Data table to the Date column of the Date Table. In the Date Table, write calculated column formulas to extract Year, Month Name and Month Number. Sort the Month Name by the Month number. To your visual, drag Year and Month Name from the Date Table. Write this measure
Total hours = sum(Data[hours])
Hope this helps.
Helper IThanks Ashish_Mathur
How would I create the custom columns for 2020 and 2021? Can't figure out how to write that.
- Ashish_Mathur
Hi,
If you want to create a Calendar Table for 2020 and 2021, then simply write this Table formula
Calendar = calendar(date(2020,1,1),date(2021,12,31))
Now add as many calculated columns as you want to this Calendar Table.