Hello,
I have the a very large dataset with 50 different attributes and a small number of values which require aggregating.
The requirements are that the user must be able to select at least two attibutes to display on a matrix. The values remain static.
A small generic example of the raw data set is as follows:
Age Gender EyeColour Weight Sale Premium Cxx
| 15 | F | Blue | 12 | 1 | 50 | 0 |
| 26 | F | grey | 16 | 1 | 49 | 1 |
| 56 | M | blue | 17 | 1 | 36 | 0 |
| 25 | F | blue | 24 | 1 | 78 | 0 |
| 53 | F | grey | 12 | 1 | 73 | 0 |
The end result would allow the user to select 2 attributes from Age, Gender, EyeColour and Weight in order to analyse the Sale, Premium and Cxx values by. The require the data to appear in a tabular format so I am working on the basis that a matrix is the best choice.
I have read an excellent post here https://powerpivotpro.com/2018/01/dynamic-attributes-power-bi-report/ on allowing a user to select multiple measures to appear on a graph using the SWITCH command but I cannot find anything about doing something similar on a matrix with dynamic attributes.
Please let me know if you require further information.
