Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

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

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. 

 

Capture.JPG

 

 

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

 

Best regards

 

Sven 

1 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

 

View solution in original post

3 REPLIES 3
v-gizhi-msft
Community Support
Community Support

Hi,

 

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

+0%;-0%;0%

25.PNG

The result shows:

26.PNG

Hope this helps.

 

Best Regards,

Giotto

Anonymous
Not applicable

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

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

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Users online (2,251)