Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |