Forum Discussion

SAG1's avatar
SAG1
Helper I
9 years ago
Solved

Interactive parameter report

Hello

 

I need to create a PBI report , which will have Month and Year as drop down for user to select and based on that Matrix will popupate , how can i achieve it ? parameters will not help at user end ?

Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi SAG1

     

    If you have a Month and Year column in one of your data tables you can drag each of these to the report canvas and turn them into Slicer visuals, whcih will act as filters.  

     

    Then any other visual you create using data from the same table (or one with a valid relationship) will be filtered when the user selects a year or month.

1 Reply

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Hi SAG1

     

    If you have a Month and Year column in one of your data tables you can drag each of these to the report canvas and turn them into Slicer visuals, whcih will act as filters.  

     

    Then any other visual you create using data from the same table (or one with a valid relationship) will be filtered when the user selects a year or month.