Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
HI @Anonymous,
I don't think your scenario is suitable for dynamic attributes visuals.
First, matrix need to setting row axis, for your scenario, dynamic attribute column need to use on column field, if you used it on rows field, matrix will drill to detail attribute as list.
In addition, switch function not support to split summarized records to different category.
Regards,
Xiaoxin Sheng
Thanks for your response. Are you able to suggest another way I can meet the requirement without using a matrix?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |