Skip to main content
Marching toward a simplified navigation! READ ON
Showing results for 
Search instead for 
Did you mean: 

drill down in bar chart


I have a bar chart with dimension year and month.

For Year month a drill down has been created .

when we select a year it gets drilled to those months and the user can see all the months for for the selected year.

but the requirement is along with those associated month the non selected year should also be displayed.


Eg:- Suppose i have selected 2020 so it will show Bars for JAN , FEB,MAR,APR AND 2018 AND 2019.


Attached is the application for reference.

2 Replies
Specialist III
Specialist III

Create one more field in script with below condition and use that in your drill-down dimension.

if(Year (Date) = Year(Today()) , Month(Date) , Year(Date))  as Month_Drill


Former Employee
Former Employee

Another option would be to look at using Set Analysis to display the other years, here is a Design Blog post that should allow you to check that option out in further detail:


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.