Forum Discussion
jeoosma
8 years agoHelper II
Bar charts
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...
- 8 years ago
this was already answered here:
https://community.powerbi.com/t5/Desktop/Separate-data-by-year-and-month-to-show-trending/m-p/414617#M190324you need to use the 'fork' drill down, rather than 'two arrows' drilldown
Stachu
8 years agoCommunity Champion
this was already answered here:
https://community.powerbi.com/t5/Desktop/Separate-data-by-year-and-month-to-show-trending/m-p/414617#M190324
you need to use the 'fork' drill down, rather than 'two arrows' drilldown
- jeoosma8 years agoHelper IIOk, 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)?
- Stachu8 years agoCommunity Champion
you may consider creating a custom theme
https://powerbi.tips/tools/advanced-color-theme-generator/