Formatting questions - can you.....

[Sportily]

Hi,

I hope its ok to ask some basic formatting questions:

1) Is it possible to apply backgorund shading to some columns in a table, but not others? I'd like the final column to stand out, but can't find where to do this.

2) I have a card which a measure in it and it is displaying with a % sign after the figure. I have a very similar card, with a very similar measure in it, but this is displaying without a % sign. What drives the adding of the display of the sign? I cant find a setting anywhere for that.

Thanks so very much

[amitchandak · Accepted solution]

@Sportily , For the first one you might have to use Image

for the 2nd , please check measure or column tools, there is % icon , press that.

Or give format there like ###.00%

[hashtag_pete · Accepted solution]

Hi @Sportily 

when selecting the measure where you want to have a different format, you can see in the ribbon the formatting option (similar to Excel)

regarding the background of one special column, you can for example make a conditional formatting:

if this helps, please accept as solution and give kudos 🙂

best hashtag_pete

[Sportily]

Ah, found the ribbon, sorry. Doh!
Thank you

[amitchandak · Accepted solution]

@Sportily , For the first one you might have to use Image

for the 2nd , please check measure or column tools, there is % icon , press that.

Or give format there like ###.00%