Post reply

Remove Specific Object in the Chart in SSRS

  • November 8, 2013 at 8:27 am

    #282234

    Goal:

    Display the chart without displaying "Bikes", "Bikes - Internet Sales Amount" and "Bikes - Internet Tax Amount". Please review at pictures.

    However, "Bikes", "Bikes - Internet Sales Amount" and "Bikes - Internet Tax Amount" shall be available in the list but not in the chart.

    Problem:

    I do not know how to remove "Bikes", "Bikes - Internet Sales Amount" and "Bikes - Internet Tax Amount" in the chart.

    Information:

    *I'm using SQL server 2012

    *The data source is SSAS from AdvenctureWorks.

    SELECT NON EMPTY

    {

    [Measures].[Internet Standard Product Cost],

    [Measures].[Internet Sales Amount],

    [Measures].[Internet Total Product Cost],

    [Measures].[Internet Tax Amount]

    } ON COLUMNS,

    NON EMPTY

    {

    ([Customer].[Customer Geography].[Customer].ALLMEMBERS * [Product].[Product Categories].[Product].ALLMEMBERS )

    } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS

    FROM

    [Adventure Works] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

  • November 8, 2013 at 2:49 pm

    #1665235

    You can just add a filter on the Category in the chart.

    I'd suggest you look up "data regions" in SSRS to help you understand the scope of filters and what will be affected. E.g. filtering the dataset would affect both the chart and the table, filtering the chart (which is a data region) will not affect the table, and visa versa.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply