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 - 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)
User | Count |
---|---|
75 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |