How to change pie chart series (columns) based on the parameter selection from one column to another.


Hi,

I have a situation where i need to switch pie chart from one column of dataset to another based on the selection made from dropdown list of parameter values.

e.g., I have three columns dataset Column1, Column2 and Column3 all are listed in dropdown of a parameter  i.e., par1. When I make a selection from dropdown from column1 to column2 the pie chart should change to column2 values.

I have tried to achive this by setting visibility property of the series of column1,2 and 3 using expression to true and false based on parameter selection but, it did not work.

Your help and advice will be greatly appreciated.

Many thanks.
ezkhanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Nico BontenbalConnect With a Mentor Commented:
You could use an expression for the data series that goes something like this:
=iif(par1="Col1",Col1,iif(par1="Col2",Col2,Col3))
0
 
ezkhanAuthor Commented:
Any Comments Please!!!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.