Stacked chart and date drilldown

[FoolzRailer]

Hello

I have a two tables with date/time and several columns worth of data in each. I have for each created a Date column without the time, and created a separate table with just a Date in it as well. All Date tables are set up with a hieracy Year, Qtr, Month, Date and the two tables with date have a Many-One relationsship with the Date table. 

I currently have a stacked chart with axis as date and values set to max. My problem is when I would like to click 2012 for example, and then the Stacked bar chart should zoom in and show values spread out over 2012 from january-december.  Instead it just shows the values for that year as dot. 

How do I go about getting it to "zoom" correctly to that area? Or for instance can I use a Slicer with dates and then get it too zoom after that? 

[timg]

Hi ,

Could you verify whether you are using the date or the year in the axis? If you have the date selected, it should still show all dates within the year interval you filter. If you used year in the axis it will indeed only return a dot since it will aggregate the values by year. Below you'll find an example:

Best regards,

Tim

[FoolzRailer]

I have the hierachy added. 

[FoolzRailer · Accepted solution]

It seems I can get around it if i Click on a year in my Matrix, and afterwards right-click my Stacked Chart and use Expand to next level (paraphrasing, my language is danish).

Then I can get it too show values like I would have them. But is possible to this as default and dynamicly with the matrix? 

[timg]

A yes I see, yeah you can have the visual automatically change the axis size/labels by placing only the date column in the axis (not the hierarchy). the hierarchy will fix the visual on the level you have drilled down to. When just using the date column it will automatically change the labels based on how large your selection is.