Detailed Bar Chart Problem

[#1]

Hey all,

I have a problem with a bar chart I'm trying to create.

I want to have one bar chart that gives an overview of all Entities like so below:

And when I click on an Entity it should show the corresponding Attributes of that Entity, like so:

I already managed to do this by specifying the Attributes dimension like this:

=If(Len(GetFieldSelections(ValidatieEntiteit))>1,ValidatieAttribuut)

This works, but I still have some problems with how it all looks and works.

- Is this good practice to do it like this?

- I can't get the legenda to show in the first Entity bar chart, how-to fix?

- First Entity chart doesn't show multicolored bars. I know I can fix this manually by using a expression for the background color, but is it possible to do it automatically?

Thx!

[#2 · Accepted solution]

Try to create the Drill down group of  Entity and Attribute then show it as dimension

[#3]

Thx!

I knew that it should be possible with an easier approach.