Problem with text format in expression ()

[Anonymous]

Hi Guys,

I've got a problem with my stacked bar-chart.

It's pretty simple, I'm summarizing sales values per location and product.

The problem is that I've to differentiate between internal sales and external in the same chart.

If it's an Internal-sale the number on the bar should be bold and/or italic if not it should be unchanged.

How can I create an expression (in text format in expressions) to make it work?

Is there any function to make a string/number bold or italic?

Thanks a lot

Mathias

[montubhardwaj · Accepted solution]

Hi Mathias,

Click on (+) sign infront of your Expression. From there you have to choose "Text Format" option. There in the condition box, you can give condition like below:

If(Sales>1000,'<B>')

So if the sales is more than 1000, those cells will be in bold and rest as normal. See the attached.

[Anonymous]

Hi Sharma,

thank you very much! You helped me a lot!

Is this info written down somewhere? Or where did you get this info from?

Kind Regards

Mathias

[montubhardwaj]

hi Mathias,

I had to do similar kind of formatting sometime back in my project. So kinda I know it. I thought a snapshot will help you better, so I just did this.

No issues mate... I ma happy that my experiance ,somehow , was helpful for you!

Cheers,

Sharma