Forum Discussion
Solved
How to plot Year to Date Earnings
Hello, I have the table as picture 1 shows below. And I want to plot Year to Date Earnings.
But when I select column visualization, it only shows the total earnings of year 2018, which is only one column (please refer to picture 2).
How could I solve this issue? Thank you.
- Hi@zhuoweiDates are an unique type of hierarchy. When you add a date field to a visualization, Power BI automatically adds a time hierarchy that contains year, quarter, month, and day.So you need to drill-down your visual like this :Best Regards,Lin
2 Replies
v-lili6-msftCommunity Support
Hi@zhuoweiDates are an unique type of hierarchy. When you add a date field to a visualization, Power BI automatically adds a time hierarchy that contains year, quarter, month, and day.So you need to drill-down your visual like this :Best Regards,LinThank you so much Lin. It really works.
