Combo chart dynamic measures selection

[AkshayShah]

Hello

I am looking for a combo chart that dynamically adjusts its measures based on user selection. Using the bar chart, I can achieve what I want, but the combo chart is not working as expected.

Is there any way to resolve this issue using expression or variables

I have attached the sample report.

Below is the screen shot for reference.
If I am selecting multiple Products, combo chart is not showing the result.

If I am selecting any one product it is working.

[Antoine04]

Hello,

I checked your qvf file.

It's not working because your field below is not visilbe in the chart.

You need to use another way. Let me try.

Regards,

Antoine

[Antoine04]

Would something like this resolve your problem ?

Regards,

Antoine

[akshayshah11]

Hi @Antoine04,

Thank you for your reply. However, this approach is not flexible, and there is no option to hide or show the measures in charts depending on user selection.

.

.

[Antoine04]

Hello @akshayshah11 ,

I managed to do it with the combo chart, as you can see below :

Here are the formulas measures you need to write :

- Books : If(WildMatch('$(=Concat(AdhocMes_FieldNames,' ,'))', '*Books*'), Sum(Books),0)

- Box : If(WildMatch('$(=Concat(AdhocMes_FieldNames,' ,'))', '*Box*'), Sum(Box),0)

- Glue : If(WildMatch('$(=Concat(AdhocMes_FieldNames,' ,'))', '*Glue*'), Sum(Glue),0)

- Pencil : If(WildMatch('$(=Concat(AdhocMes_FieldNames,' ,'))', '*Pencil*'), Sum(Pencil),0)

What do you think ? 😉

[akshayshah11]

Hi @Antoine04,

Is it feasible to keep other products out of Toot tip and Legend?

[Antoine04]

Unfortunately no, I would recommend to hide the legend and create your own with the text objet.

Regards,

Antoine