Skip to Content
avatar image
Former Member

Xcelsius Bar Chart dynamic Y Axis Lables

Dear Experts,

I need to combine two bex querys in Xcelsius.

My Requirement.

I have two bex querys in my Xcelcius.

First Query Contains objects like KPA ID, KPA Name

second querys contains KPI ID,KPI Name,KPA ID,Sales,Profit.

I have a combobox(KPA Name)

KPA Name ( New york, California,Alabama)

If I Select New york in my combobox i need to display KPI Name in my Bar chart Y axis Lable and profit in X axis lable.

here tricky is in New york we can have multiple KPI Name which are not same as California and alabama.

Supose if ii select California in my combobox I need to Display Different KPI names In My Bar Chart Y axis Lable.

I don't want to create multiple bar charts in single chart i need to solve this requirement.

we have almost 20 to 30 records in KPI Name.

I hope my requirement is clear for you.

Please assist me to solve this issue.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers