Interactive parameter report

[SAG1]

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 ?

[Phil_Seamark · Accepted solution]

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.