Container visualization

[MISOG]

I have a pivot table that has a dimension BusinessUnitNameAbbr and a measure TariffCodeHours. I need to add a container in which there will be 2 bar charts with measure TariffCodeHours. Bar chart 1 will have the dimension BusinessUnitNameAbbr. Bar chart 2 will have the dimension TariffCodeNameGroupEN.

Bar chart 1 will be visible when no BusinessUnitNameAbbr is selected.

Bar chart 2 will appear when atleast one BusinessUnitNameAbbr is selected.

How to set the conditions to get required result?

[SRA · Accepted solution]

Hi, 

You could use a display condition on the content management of you container with :

On chart 1 : GetSelectedCount(BusinessUnitNameAbbr) = 0

On chart 2 : GetSelectedCount(BusinessUnitNameAbbr)

Regards

[MISOG · Accepted solution]

Hi SRA,

Thank you for your advice. It works 👍

Actually I used following solution in "Show condition":

On chart 1 : GetSelectedCount(BusinessUnitNameAbbr) = 0

On chart 2 : GetSelectedCount(BusinessUnitNameAbbr) > 0

But your solution is even siplier.

Have a nice day!