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.
Hi,
I am coming with matrix issue, i have no idea how to adress..
My requirement is to build layer matrix visualization with proper comments in it.
I want to achieve below:
My Data source look like that :
Category | Sub Category | Sub-SubCategory | Value I | Value II | Notes |
Main Category | Sub Category I | SubSubCategory I-I | 0 | 0 | SubSubCategory I-I Comment |
Main Category | Sub Category I | SubSubCategory I-II | 1 | 1 | SubSubCategory I-II Comment |
Main Category | Sub Category II | SubSubCategory II-I | 2 | 2 | SubSubCategory II-I Comment |
Main Category | Sub Category II | SubSubCategory II-II | 3 | 3 | SubSubCategory II-II Comment |
Main Category | Sub Category III | SubSubCategory III-I | 4 | 4 | SubSubCategory III-I Comment |
Main Category | Sub Category IV | SubSubCategory IV-I | 5 | 5 | SubSubCategory IV-I Comment |
Main Category | Sub Category IV | SubSubCategory IV-II | 6 | 6 | SubSubCategory IV-II Comment |
Main Category | Sub Category IV | SubSubCategory IV-III | 7 | 7 | SubSubCategory IV-III Comment |
Main Category | 8 | 8 | Main Category Comment | ||
Main Category | Sub Category I | 9 | 9 | Sub Category I comment | |
Main Category | Sub Category II | 10 | 10 | Sub Category II comment | |
Main Category | Sub Category III | 11 | 11 | Sub Category III comment | |
Main Category | Sub Category IV | 12 | 12 | Sub Category IV comment |
Could you please help me out finding a proper measure which will take the proper comment to poper line ?
Maybe i should change something in datasource ?
Thanks in advance!
Solved! Go to Solution.
Hi, @Kopek
You may achieve your requirement with matrix visual. 'Category', 'Sub Category' and 'Sub-SubCategory' fields are put in 'Row'. 'Value I', 'Value II', 'Notes' fields are put in 'Values'. You need to set the aggregation for 'Notes' as 'First'.
Result:
Best Regars
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Kopek
You may achieve your requirement with matrix visual. 'Category', 'Sub Category' and 'Sub-SubCategory' fields are put in 'Row'. 'Value I', 'Value II', 'Notes' fields are put in 'Values'. You need to set the aggregation for 'Notes' as 'First'.
Result:
Best Regars
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi. The thing about the matrix is that the value must be aggregated. In case of text, you can use MAX/MIN or LAST/FIRST to the text column (NOTES). Create a measure like that MAX('Table'[Notes])
Hope that works.
Happy to help!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |