Solved

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

Posted on 2011-09-03
2
524 Views
Last Modified: 2012-05-12

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.
0
Comment
Question by:ezkhan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Author Comment

by:ezkhan
ID: 36480008
Any Comments Please!!!!!
0
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 500 total points
ID: 36480618
You could use an expression for the data series that goes something like this:
=iif(par1="Col1",Col1,iif(par1="Col2",Col2,Col3))
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question