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,
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
Solved! Go to Solution.
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
I used Calculated column instead of measure and it worked.
Thanks for your help
It is now almost 2024. We have flying cars now. Did Microsoft create a way for people to bold a row in a table in their highly touted Power BI application???
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
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?
@rajendraongole1
Is it possiable to Bold whole row in the Matrix/Table formatting?
I want to make it bold for whole WW row.
Thank you
Regards,
Hari
I used Calculated column instead of measure and it worked.
Thanks for your help
Ended up with background color instead of BOLD text for the above issue
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 | |
100 | |
78 | |
75 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |