Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Community,
Now I have a matrix, where I want to bold only "First value", "Second value" without changing the font of the other row headers.
is it possible?
Thank you.
Solved! Go to Solution.
I am not sure if you can bold certain rows, what you could however do is change the "Style presents" to e.g. Minimal and then use conditional formatting for the rows, so that when value = entry, then use centrain background colour so it would stand out.
Hi @Anonymous
Based on the information you provided, the following is the case description: You need to bold certain row headings in the matrix.
I am not sure if your data has a hierarchical structure or how your matrix was created, here are my tests:
Data has a hierarchical structure:
My sample:
If the data has a hierarchical structure, then the row headings are automatically bolded:
Data does not have a hierarchical structure:
My sample:
The effect of bolding the line headings is not possible in this case, here is my suggestion:
1. Create a measure as follows:
Measure =
switch(
TRUE(),
SELECTEDVALUE('Table'[entry]) = "First value", "orange",
SELECTEDVALUE('Table'[entry]) = "Second value", "orange"
)
2. Operate as shown in the following screenshot:
For more information about the conditional format, you can refer to the following link: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
If I've misunderstood you, please provide detailed information. We can better understand the problem and help you. Show it as a screenshot or excel. Please remove any sensitive data in advance.
Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Based on the information you provided, the following is the case description: You need to bold certain row headings in the matrix.
I am not sure if your data has a hierarchical structure or how your matrix was created, here are my tests:
Data has a hierarchical structure:
My sample:
If the data has a hierarchical structure, then the row headings are automatically bolded:
Data does not have a hierarchical structure:
My sample:
The effect of bolding the line headings is not possible in this case, here is my suggestion:
1. Create a measure as follows:
Measure =
switch(
TRUE(),
SELECTEDVALUE('Table'[entry]) = "First value", "orange",
SELECTEDVALUE('Table'[entry]) = "Second value", "orange"
)
2. Operate as shown in the following screenshot:
For more information about the conditional format, you can refer to the following link: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
If I've misunderstood you, please provide detailed information. We can better understand the problem and help you. Show it as a screenshot or excel. Please remove any sensitive data in advance.
Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am not sure if you can bold certain rows, what you could however do is change the "Style presents" to e.g. Minimal and then use conditional formatting for the rows, so that when value = entry, then use centrain background colour so it would stand out.
User | Count |
---|---|
73 | |
72 | |
39 | |
25 | |
23 |
User | Count |
---|---|
96 | |
93 | |
51 | |
43 | |
42 |