Forum Discussion
Adding different Colours for different Row headers in Matrix in Power BI.
Hi srinivas_fabric,
Thanks for reaching out to the Microsoft fabric community forum.
I recreated the sample data using the screenshot you provided.
Unpivot the Data
In Power Query, select the columns 2022, 2023, and 2024, right-click and choose "Unpivot Columns," then rename the resulting columns to Product, Year, and Sales.Create a Row Color Measure
Measure:
RowColor =SWITCH(
SELECTEDVALUE('Sales'[Product]),
"Smartphones", "#FFCCCC", // Light Red
"Laptops", "#CCE5FF", // Light Blue
"Tablets", "#D5F5E3", // Light Green
"Headphones", "#FFF2CC", // Light Yellow
"Smartwatches", "#E6CCFF", // Light Purple
"#FFFFFF" // Default White
)
Build the matrix by placing Product in Rows, Year in Columns, and adding both Sales and Product to Values (the second Product is for coloring). Then, apply conditional formatting by clicking the dropdown on the second Product field, choosing Conditional formatting > Background color, and setting it to format by field value using the RowColor measure.Please go through the screenshot and pbix file for detailed information.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Menaka.
Community Support Team
srinivas_fabric If you are limited in creating a new table, you can create a measure as shown below and use it for conditional formatting.
RowColor =
SWITCH(
[RowCategory],
"Category A", "#FF0000", // Red
"Category B", "#00FF00", // Green
"Category C", "#0000FF", // Blue
"#000000" // Default Black
)
You can explore custom visuals from the marketplace like:
- TableSorter or Matrix by MAQ Software
- Acterys Matrix Light
Some of these visuals offer more flexible formatting, including row header styling.
Thanks for your Answer.Please let me explain by applying on this Sample data.
Thank you for your Solution .Please let me explain by applying on this Sample file.
Hi srinivas_fabric,
Thanks for reaching out to the Microsoft fabric community forum.
I recreated the sample data using the screenshot you provided.
Unpivot the Data
In Power Query, select the columns 2022, 2023, and 2024, right-click and choose "Unpivot Columns," then rename the resulting columns to Product, Year, and Sales.Create a Row Color Measure
Measure:
RowColor =SWITCH(
SELECTEDVALUE('Sales'[Product]),
"Smartphones", "#FFCCCC", // Light Red
"Laptops", "#CCE5FF", // Light Blue
"Tablets", "#D5F5E3", // Light Green
"Headphones", "#FFF2CC", // Light Yellow
"Smartwatches", "#E6CCFF", // Light Purple
"#FFFFFF" // Default White
)
Build the matrix by placing Product in Rows, Year in Columns, and adding both Sales and Product to Values (the second Product is for coloring). Then, apply conditional formatting by clicking the dropdown on the second Product field, choosing Conditional formatting > Background color, and setting it to format by field value using the RowColor measure.Please go through the screenshot and pbix file for detailed information.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Menaka.
Community Support TeamHi srinivas_fabric ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Best Regards,
Menaka.
Community Support TeamHi srinivas_fabric ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Best Regards,
Menaka.
Community Support Team
