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.
Two questions that hopefully have answers:
1. The Plus (+) and Minue (-) icons for rows in a Matrix. Is there a way to show this by Row? I want to allow users to expand out certain Account Groups, but not see that option for others. Example: Expand Revenue Group row? Yes. Expand Gross Margin row? No.
2. Conditionally formatting a row header. Similar to this, I would like to format specific rows in may matrix. I can format the measures fine to a different shade of color, but want to match that on the row header for that row and leave all the others the same. Is this possible?
Thanks in advance!
Solved! Go to Solution.
Hi @Razorbx13,
Nope, current power bi matrix visual not support these summary rows. Its total row is analyzed by power bi and grouped based on category fields.
For your scenario, you need to create a new table with subcategory type and custom fields, then write measure expression to replace row value field to use the current value switch function to show different values.
My Favorite DAX Feature: SELECTEDVALUE with SWITCH
Regards,
Xiaoxin Sheng
Hey @Razorbx13 ,
about your questions:
1. Sadly not, you can either activate or deactivate them, but just for all rows. You cannot differentiate
2. The headers cannot be formatted as the conditional formatting is about values and the header doesn't have values.
Sorry for that.
Thank you. I was hopi g I could change the background of the values and then apply to label like you can do for all total rows. For me it is just a few of the subtotal rows of the matrix I need to do this. Leave all the others as a default.
Hi @Razorbx13,
Nope, current power bi matrix visual not support these summary rows. Its total row is analyzed by power bi and grouped based on category fields.
For your scenario, you need to create a new table with subcategory type and custom fields, then write measure expression to replace row value field to use the current value switch function to show different values.
My Favorite DAX Feature: SELECTEDVALUE with SWITCH
Regards,
Xiaoxin Sheng
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |