Incorrect Representation of Data

[espinozan]

Hi,

I am using Calendar to select timeframe and a bar chart to show the trend.

I have data from January 2016-Present. When I select everything in the timeline i.e. from Jan'16 to Apr'17 and click on "Go to next level in hierarchy", it takes me down from Year-Level to Quarter-Level.

The issue is, it automatically adds all data of Jan'16, Feb'16, Mar'16 with Jan'17, Feb'17, Mar'17 to Q1. It should show the Quarterly data by year not combine it all at once. 

How can I fix this issue? I have not been able to find a solution. I understand that the "Expand All down" gives the desired result, but to a new user this will be confusing and may hider the company because of how it's represented if the user isn't aware.

Thanks for your help.

[v-chuncz-msft · Accepted solution]

@espinozan,

You may drag Date column to Legend field, and select Date Hierarchy. You can also turn on Drill Down.

https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-3-11g-visual-hierarchies-drilli...

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-drill-down-in-a-visualization/