This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
Hello - I am trying to bold the highest number in each ROW w/ conditional formatting.
Hi @jcastr02 ,
We can set conditional formatting based on the measure like that.
Measure =
VAR a =
MAX ( 'Table'[category] )
VAR maxv =
CALCULATE (
MAX ( 'Table'[valu] ),
FILTER ( ALL ( 'Table' ), 'Table'[category] = a )
)
VAR valu =
MAX ( 'Table'[valu] )
RETURN
IF ( valu = maxv, "red" )
Pbix as attached.
@v-frfei-msft Thank you - was looking to see instead of the red box we could bold the text?
Hi @jcastr02 ,
Please set the conditional formatting of the font color instead of background color.
Then we can get the excepted result as below.
Pbix as attached.
Is there a way to just bold the number in black font, and not change the color to red?
Hi @amitchandak
I'm curious. It is possible to create bold texts using a condition measure?
Hi @jcastr02 ,
I do not think that is a current feature. There are other prior post similar to this. For the meantime, you may vote for this idea.
additional font formatting (bold, italic, underline, etc)
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 29 | |
| 22 | |
| 22 | |
| 20 | |
| 20 |