show just month in chart axes

[nazaninslp]

Dears

I have below chart in QV:

I want show just month name in my chart and when user click on month name in chart, it show 30 days of mentioned month.

like below chart :

would you please help me?

dimension : DATE_KEY

Expression: sum({<Area_Category-={"Test","Free ShortCode","Xtratime","ACS"}>}REVENUE)

[swuehl · Accepted solution]

Use a drill down dimension group (you can edit the groups on dimension tab of your chart or in document properties) with dimensions Month and Date.

[nazaninslp]

Thank youuuuuuuuuuuuuuuuuuuuuuu