Forum Discussion
zhuowei
8 years agoFrequent Visitor
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 c...
- 8 years agoHi@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
v-lili6-msft
Community Support
8 years agoHi@zhuowei
Dates 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
- zhuowei8 years agoFrequent Visitor
Thank you so much Lin. It really works.