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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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