Forum Discussion
Matrix/Table formatting - BOLD row
Hi,
Need help in formatting one row to be bold in the Matrix.
I ca use a table too...
| Items | Value |
| A | 10 |
| B | 20 |
| C | 30 |
| D | 10 |
| E | 10 |
| Total | 80 |
Thanks
Create a basic measure to give the row you need highlighted a value and then apply conditional formatting with a rule.
For example if i had this table:
Example V 1 V 2 A 1 5 B 2 6 C 3 7 D 4 8 suppose i wanted the row with all 'D' to be highlighted, i could create the following measure:
Measure = IF(Table[Example] = "D", 1, 0)
I can then apply the conditional formatting for each column using the rule and value =1
In conditional format use the rule and call that measure.
Regards,
Rajendra
8 Replies
Create a basic measure to give the row you need highlighted a value and then apply conditional formatting with a rule.
For example if i had this table:
Example V 1 V 2 A 1 5 B 2 6 C 3 7 D 4 8 suppose i wanted the row with all 'D' to be highlighted, i could create the following measure:
Measure = IF(Table[Example] = "D", 1, 0)
I can then apply the conditional formatting for each column using the rule and value =1
In conditional format use the rule and call that measure.
Regards,
Rajendra
Conditional formats for tables and matrices do not include bold, italics, or font size/style (with the exception of font color). It seems as though the original post has not been addressed. Google results are scant on this topic.
I followed the mentioned steps, but am not aware on how to apply the bold format tp the entire row based on the measure created? can any one help on this?
If you have an Excel table with specific formatting that you want to bring to Power BI, watch this video where it is explained how this can be done:
How to create any Excel table in Power BI using the HTML & CSS Viewer Visual
https://youtu.be/6JYVqE4UK7M
