Forum Discussion
Calculated columns - Format specific row value in Bold
Hi All,
Please suggest how to format specific Row in Bold, EX- I’m using below calculated column in table and I would like to highlight Gross Sales and Net Sales in Bold.
Account Indent =
SWITCH(
TRUE(),
'Table’[account_desc] = "Gross Sales",""& 'Table'[account_desc],
'Table’ [account_desc] = "Sales Returns"," "& 'Table'[account_desc],
'Table’'[account_desc] = "Rebates", " "& 'Table'[account_desc],
'Table’ [account_desc] = "Net Sales", ""& 'Table'[account_desc],
'Table’ [account_desc] = "Alliance"," "& 'Table'[account_desc]
)
Hi! Snagalapur
You can use conditional formatting for this to give a background or different text color. I don't think we can make the value bold separately in the visuals, but with conditional formating you can make it stand out.Hi Snagalapur ,
Power BI does not support bold formatting directly in DAX expressions for specific rows in a table visual. However, you can achieve the visual effect of bolding rows like "Gross Sales" and "Net Sales"using one of the following workaround:-
Go to the table visual.
-
Select the column where your sales names appear.
-
Click on the "..." > Conditional formatting > Font color or Background color.
-
Use Rules or Field value based on the account_desc values.
-
Set a darker font or highlighted background for "Gross Sales" and "Net Sales".
Hope this helps!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.-
5 Replies
Hi! Snagalapur
You can use conditional formatting for this to give a background or different text color. I don't think we can make the value bold separately in the visuals, but with conditional formating you can make it stand out.Hi Snagalapur ,
Power BI does not support bold formatting directly in DAX expressions for specific rows in a table visual. However, you can achieve the visual effect of bolding rows like "Gross Sales" and "Net Sales"using one of the following workaround:-
Go to the table visual.
-
Select the column where your sales names appear.
-
Click on the "..." > Conditional formatting > Font color or Background color.
-
Use Rules or Field value based on the account_desc values.
-
Set a darker font or highlighted background for "Gross Sales" and "Net Sales".
Hope this helps!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.-
Hi Snagalapur ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank YouHi @Snagalapur ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank YouHi @Snagalapur ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You