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.
I am having trouble making a Matrix table display the way I would like. Below is an example of my issue. On the left is an image of how the Matrix table is displaying the results. Note that the KAM group in broken into two sections based on the team. I would like the results to display like the right example which National and Exc. National fall under the same KAM group. This would allow for a total line for all of KAM versus two different KAM totals. Below this image is a screen shot of the data table that I am using to set this up. Is there a better table structure that would allow the right image version to work?
Hi @Anonymous,
I think the issue may related to records, please double check if these column contains whitespace.
You can use replacevalue function to remove whitespace in power query:
Remove=Table.ReplaceValue(#"Changed Type"," ","",Replacer.ReplaceText,{"ColumnName"})
Regards,
Xiaoxin Sheng
Hi @Anonymous
If you use the Matrix and put in the Group, Team and Demand Group under the Rows it will group as you want it to in your image on the right hand side.
Alas they are all under rows...any other possibilities?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |