locked
Dynamically selecting values for filter in power pivot RRS feed

  • Question

  • Hi,

    I am creating a power pivot report. I want the values of its filters to be set dynamically based on certain critreria. For Example, if some one changes the Iteration Path then the range of dates should change automatically to Iteration start date - Itearation End Date.

    Is there any way to set filter values based on some calculation.

    Any help in this regard will be highly appreciated.

    Thanks,

    Bhawna.


    Bhawna Aggarwal

    Monday, June 30, 2014 11:39 AM

Answers

  • Check out the Event-In-Progress pattern as described here:
    http://cwebbbi.wordpress.com/2013/06/13/a-new-events-in-progress-dax-pattern/

    basically you need to create a separate measure which to do the specific filtering for you

    hth,
    gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    • Proposed as answer by Michael Amadi Tuesday, July 1, 2014 3:48 PM
    • Marked as answer by Michael Amadi Wednesday, July 9, 2014 10:35 AM
    Tuesday, July 1, 2014 10:34 AM
    Answerer

All replies

  • Hi Bhawna,

    I think its possible using idea similar to DAX pattern Parameter Table.

    More details you can get here: http://www.daxpatterns.com/parameter-table/

    -- Paul

    Monday, June 30, 2014 6:22 PM
  • Check out the Event-In-Progress pattern as described here:
    http://cwebbbi.wordpress.com/2013/06/13/a-new-events-in-progress-dax-pattern/

    basically you need to create a separate measure which to do the specific filtering for you

    hth,
    gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    • Proposed as answer by Michael Amadi Tuesday, July 1, 2014 3:48 PM
    • Marked as answer by Michael Amadi Wednesday, July 9, 2014 10:35 AM
    Tuesday, July 1, 2014 10:34 AM
    Answerer