Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
Is there a way in my power BI report where I can create a dynamic pivot table? I created a matrix visual for the last 5 fiscal years. I am wondering if its possible where I bring in some fields beside the table and users would be able to pull these into the table to create their own table.
Hi @ROCKYDO12
Most probably what you are looking for can be acieved through Perspective in Power BI. It svery powerful for dynamic views. Other than columns' axis you will be able to change the chart itself if required.
Get a new Perspective on your Power BI dataset – Robert J Blackburn
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
79 | |
79 | |
59 | |
36 | |
33 |
User | Count |
---|---|
92 | |
59 | |
59 | |
49 | |
41 |