Hide/Show Column in Table Visual Matrix on Report

I reckon you can but you have to be quite tricky with DAX and pivot your data.

So the underlying table would have a column that represented the axis to be added to Columns

something like

ColType                Actual Value

---------                -------------

ID                          1            

Value                     20          

Percent of Value    15     

ID                           2

Value                     50 

Percent of Value    18

Then you could add [colType] to columns and use a new dynamic dax based measure to only return a value based on a filter selection

I think the only downside is you are stuck with a single data formatting setting so couldn't have whole number and percent.

I can mock something up if interested.