I’m asking if there is: a) native feature of PBI, b) downloadable visual, or c) some technique based on a DAX expression, that will allow a user to switch dimension and attributes used in visual.
By user I’m referring to someone accessing a report published to the PBI service – so not able to change layout via PBI Desktop.
The screenshot below gives an idea of what I’d like to be able to achieve. In desktop I envisage an additional part of the table definition where (in this example) several dimensions could be added to the values area and then made available (in combo/dropdown) to be used for grouping on the measure/value.
So, in the example both Age Grp Adult and Age Grp Children are added to the visual and one is set as default dimension the other(s) as optional but available. The when published the user will be able to select (maybe via dropdown list in column header in table) which dimension they would like to use to display and aggregate by in the table.
Any suggestions appreciated.