How to show chart for all months of current year with drill down option

[anupagrawal77]

Hi,

By default,  I want to display 'line & stack column chart' for all months of current year with drill down option. User can drip up or drill down also.

When user open report, I want below view & user should be allowed to drill up or down.

[ankitpatira]

@anupagrawal77 So in this case you will have multiple fields dropped onto Shared axis. you can go to the date field level on your visual using drill down feature. Then on right under Visualizations pane -> Filters > Visual level filter set your date field to the year that you want and save pbix file. 

Next time that report is opened in PBI desktop or when published to powerbi.com it will by default open to that year level you've filtered by and your users can drill up or down.