Bar charts

[jeoosma]

Hi guy. As you can see in first image I have a diagram with the bar of the year. If I go on the low lever (image 2) the bars have the sum of the month of two year. I'd have for every month the bar of 2017 and the bar of 2018. How Can I do? Thank you.

[Stachu · Accepted solution]

this was already answered here:
https://community.powerbi.com/t5/Desktop/Separate-data-by-year-and-month-to-show-trending/m-p/414617...

you need to use the 'fork' drill down, rather than 'two arrows' drilldown

[jeoosma]

Ok, I've put the date in data value without deleting quarter and day, now the fork works. I put the different color for 2017 and 2018 in main view. Is it possible setting the same colour when go throught the level automatically or I have to set into manually (only the first time)?

[Stachu]

you may consider creating a custom theme
https://powerbi.tips/tools/advanced-color-theme-generator/