Select certain columns from a table within a Power BI report
I have a need for users to choose which columns they select in a Power BI report, but I'm struggling to find a way to get this to work. Basically, I have a table with columns such as Contact, Address, Education, Employment etc, and I'd like the users to be able to choose whether or not they see the Education and Employment fields.
I've tried using a Slicer and Unpivoting the columns, but I get the 'UNPIVOT' statement is not supported error (I'm using Direct Query to a SQL Server).
Do you know of any other way that I can achieve this?