There's a few tricks to using field parameters with tables and matrices in Power BI. This video tutorial shows how to conditionally format your field parameters, set their width in columns, and and how to set up a clean design/userfriendly exporttoExcel experience, letting them choose if they want to export a table or a matrix.
If you're unfamiliar with field parameters, I recommend checking out this video first: • How to use field parameters in Power ...
0:00 Intro
2:25 Demo start / slicer setup
4:41 Table config
5:40 Conditional formatting table field parameters
7:35 DAX to intentionally return blank when certain parameters are selected
8:23 Excel export "hint" icon
9:42 Matrix config
10:49 Bookmark to allow viewers to swap between the table and matrix
Adding a link to the pbix (it's the file called Tutorials PBIX): https://github.com/chpayton/BIFiles