Is there a way to create a visual in power bi like a pivot table in Excel , where the fields are dynamic and the end - user can build a diffrent pivot table with diffrent fields every time. ?
This might bot be exactl solution this will guve you direction here is link for solution
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! Check for more intersing solution here: www.youtube.com/@Howtosolveprobem
While it is not currently possible to replicate the exact functionality of an Excel pivot table with user-selected fields in Power BI, you can create a dynamic pivot table-like visual using the Matrix visual and Field Parameters.
I recommend using the Field Parameters concept. This will enable users to select the specific fields they wish to view by choosing them in a slicer. For more information on how to create Field Parameters, you can refer to the following URLs
