Hello, i have a 3d clustered chart. So each series has a color to it. Now when i place my mouse on one of the values or the column it should only highlight that and all other colors as none.. so only that column is highlighted with color. If anybody has a idea about it please let me knw how i can do it Thanks Madhavi

Hi Madhavi, From your description, you want the selected series bar or bars to be highlighted and the other bars are hidden when the mouse arrow hovers over a bar in the chart. If so, I dont think this can be achieved in Reporting Services currently. To work around the issue, I suggest that you add a parameter and a drillthrough action to the report. In this way, when you click on a series bar, the report drills through to itself and filters the chart to display only select series. For example, I use the AdventureWorksDW2008 data source to create a 3D-Clustered Column Chart, the SalesAmount, SalesTerritoryGroup and CalendarYear fields are dragged into data field area, category field area and series field area separately. The steps below are for your reference: Create a multi-value hidden parameter named Year which retrieves values from the query of another dataset. Add a filter to the chart series group like below: Expression: [CalendarYear] Operator: IN Value: [@Year]Right-click on the bars in the chart to open Series Properties box. Click the Fill tab, set the color expression to: =Switch(Fields!CalendarYear.Value="2001","Red",Fields!CalendarYear.Value="2002","Blue",Fields!CalendarYear.Value="2003","Orange",Fields!CalendarYear.Value="2004","Green") Note: This step helps us to set fixed color for each instance of the series group. Click the Action tab, select Go to report, select the report itself in the drop-down list and then add a parameter as follows: Name: Year Value: [CalendarYear] The report looks like: References: How to: Add a Drillthrough Action on a Report Formatting Data Points on a Chart If you have any questions, please feel free to let me know. Regards, Mike Yin

Hi Madhavi, From your description, you want the selected series bar or bars to be highlighted and the other bars are hidden when the mouse arrow hovers over a bar in the chart. If so, I dont think this can be achieved in Reporting Services currently. To work around the issue, I suggest that you add a parameter and a drillthrough action to the report. In this way, when you click on a series bar, the report drills through to itself and filters the chart to display only select series. For example, I use the AdventureWorksDW2008 data source to create a 3D-Clustered Column Chart, the SalesAmount, SalesTerritoryGroup and CalendarYear fields are dragged into data field area, category field area and series field area separately. The steps below are for your reference: Create a multi-value hidden parameter named Year which retrieves values from the query of another dataset. Add a filter to the chart series group like below: Expression: [CalendarYear] Operator: IN Value: [@Year]Right-click on the bars in the chart to open Series Properties box. Click the Fill tab, set the color expression to: =Switch(Fields!CalendarYear.Value="2001","Red",Fields!CalendarYear.Value="2002","Blue",Fields!CalendarYear.Value="2003","Orange",Fields!CalendarYear.Value="2004","Green") Note: This step helps us to set fixed color for each instance of the series group. Click the Action tab, select Go to report, select the report itself in the drop-down list and then add a parameter as follows: Name: Year Value: [CalendarYear] The report looks like: References: How to: Add a Drillthrough Action on a Report Formatting Data Points on a Chart If you have any questions, please feel free to let me know. Regards, Mike Yin

Hi Madhavi, From your description, you want the selected series bar or bars to be highlighted and the other bars are hidden when the mouse arrow hovers over a bar in the chart. If so, I dont think this can be achieved in Reporting Services currently. To work around the issue, I suggest that you add a parameter and a drillthrough action to the report. In this way, when you click on a series bar, the report drills through to itself and filters the chart to display only select series. For example, I use the AdventureWorksDW2008 data source to create a 3D-Clustered Column Chart, the SalesAmount, SalesTerritoryGroup and CalendarYear fields are dragged into data field area, category field area and series field area separately. The steps below are for your reference: Create a multi-value hidden parameter named Year which retrieves values from the query of another dataset. Add a filter to the chart series group like below: Expression: [CalendarYear] Operator: IN Value: [@Year]Right-click on the bars in the chart to open Series Properties box. Click the Fill tab, set the color expression to: =Switch(Fields!CalendarYear.Value="2001","Red",Fields!CalendarYear.Value="2002","Blue",Fields!CalendarYear.Value="2003","Orange",Fields!CalendarYear.Value="2004","Green") Note: This step helps us to set fixed color for each instance of the series group. Click the Action tab, select Go to report, select the report itself in the drop-down list and then add a parameter as follows: Name: Year Value: [CalendarYear] The report looks like: References: How to: Add a Drillthrough Action on a Report Formatting Data Points on a Chart If you have any questions, please feel free to let me know. Regards, Mike Yin