Select dynamic fields to display in Table visual

Anonymous oh I see 🤔 Sorry I don't have a solution, though here are some approaches I've considered. Can anyone else out there help? Maybe I've missed something obvious? 

You have to keep the fact table in the original format - so you will need to do something completely different. This is because slicers work on a single column and the slicer values are the values from that column.

Out of the box, a matrix puts the values from a single column as column headers and populates from there. So you can't use that. A table allows you to put the columns across the top but there's no way to filter them.

I did think about using a solution called 'disconnected tables'. A good example is this: https://p3adaptive.com/2018/05/disconnected-slicers-with-dax-variables-selectedvalues/ 

However, this produces a slicer which will work on the rows, when you want a slicer on the columns. In other words, you want users to filter the columns but keep the original format.

The only other solution I thought is to use Calculation Groups. You end up with something similar to a slicer table which you put in the Columns section of the Matrix visual. It will then appear in the Filters pane (filters on this visual) as 'Name' and your users can then select the columns they want, and then export that. However, the export file unpivots the data back to the format we don't want! 

Sorry I couldn't help any further.