This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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 ?
Solved! Go to 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.
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.
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 36 | |
| 33 | |
| 31 | |
| 24 | |
| 18 |
| User | Count |
|---|---|
| 68 | |
| 50 | |
| 33 | |
| 24 | |
| 24 |