Need to show "+" sign in front of positive values in a barchart

[Anonymous]

Dear all, 

In a bar chart, which is working, i show positive and negative percentage values. 

The values are calcualted in a measure directly in the report. 

The negative values have automatically a "-" sign in front in the bar chart. 

The question is how to show the "+" sign in front of the positive values, for example +33 %?

Best regards

Sven 

[v-gizhi-msft]

Hi,

Please change your value custom format to this in Model pane:

+0%;-0%;0%

The result shows:

Hope this helps.

Best Regards,

Giotto

[Anonymous]

Hi, 

we are using a live connection so the model panel is not available, therefor the measure is inserted direcly in the fields.

so i should instead place the measure direcly in the dataset?

Sven

[v-gizhi-msft · Accepted solution]

Hi,

You can define your measure custom format in AS.

See this:

http://cloudbi.com.au/date-custom-format-in-ssas-tabular/ 

Hope this helps.

Best Regards,

Giotto