Group histogram with column series

[SamuelSabo]

Hi guys, 

i hope you're all okay. 

I've looked all over the internet, but haven't found the solution to my issue.

I want to create a group histogram which includes a column series. I have my Sales values and i want to compare it to last year value, while being able to see the repartition of the classes of products we sell.(cf the visual) In a optimistic future, I would also like to add other measures, such as the forecast but that's a problem for another day.   

I hope i've made myself understood despite not being a native english-speaker.

[amitchandak]

@SamuelSabo , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

I am not able to get what is data in histogram

But I still think calculation groups can help you .

https://apexinsights.net/blog/10-uses-for-calculation-groups

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Appreciate your Kudos.