Change Dashboard dynamically RRS feed

  • Question

  • Hello all

    I have a client that wants to change measures in a scorecard and an analytic chart in a dynamic way using filters. They have for example two measures in the cube (profit, sales) and they want to put them in a filter and change the data that is show to the user.

    I am not sure if this is possible.
    Thanks in advance

    Thursday, December 29, 2011 11:05 PM


  • There are a few ways of doing this for analytic chart. If you are using SharePoint 2010 PerformancePoint then there is an option on right click to switch between measures.

    OR you can modify the MDX Query tab of your report and add a calculated measure which maps to a parameter. Then map this parameter to a filter containing measure values.

    I dont think you would be able to do that with a Scorecard, since KPI are based on pre-selected Measures.

    Your option: create 2 separate Dashboard pages and name each Profit and Sale respectively. Each page containing its own scorecard and reports. You would be able to switch between both with a single click.

    Friday, December 30, 2011 4:56 PM