Format bar chart bar's to the left

[Anonymous]

I have two bar charts, I want the bottom one to be formatted, so that the bars start on the left, like the top bar chart is.

I understand why it starts from the right, because those figures are all negative, but I need it to be from the right like the top bar graph, but with the figures staying as negative.

It currently looks like this:

Does anyone know how I can do this?

I should also mention that the labels need to stay on the left.

[PaulDBrown]

@Anonymous 

One method is:

1) make your measure into positive values (measure *-1)

2) go into the modeling pane, select the measure, go to the format option, choose custom in the dropdown, and format the values to display negative values:

Open Modeling pane

Format values to display negative values:

and you can now create your bar chart:

Just beware that the measure format remains wherever you use this measure!

[Anonymous]

Were almost there, the right graph is the new one:

I changed the format to: -£#,##.##;-£#,##.##

But as you can see in the image, when the sum doesn't have any pence at the end, it just shows £15 instead of £15.00, any idea how I sort that?

[PaulDBrown · Accepted solution]

@Anonymous 

ahhh... those pesky pence causing a nuisance...😊

Try typing in: -"£"#,0.00;-"£"#,0.00

(the thousands and decimal seperators shown in the example value in my case correspond to the spanish definition (my pc local settings) so just ignore them; it should render as "," for thousands and "." for decimals for you - in other words, respecting your local settings.

[Anonymous]

Were almost there, the right graph is the new one:

I changed the format to: -£#,##.##;-£#,##.##

But as you can see in the image, when the sum doesn't have any pence at the end, it just shows £15 instead of £15.00, any idea how I sort that?

[kentyler]

Have you considered using a function like ABS() in a query to change all the numbers to positive ones. The label says "Expenses" and you could keep the red color.

I'm a personal Power Bi Trainer I learn something every time I answer a question

The Golden Rules for Power BI

1. Use a Calendar table. A custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. https://www.youtube.com/watch?v=FxiAYGbCfAQ
2. Build your data model as a Star Schema. Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! https://www.youtube.com/watch?v=1Kilya6aUQw
3. Use a small set up sample data when developing. When building your measures and calculated columns always use a small amount of sample data so that it will be easier to confirm that you are getting the right numbers.
4. Store all your intermediate calculations in VARs when you’re writing measures. You can return these intermediate VARs instead of your final result  to check on your steps along the way.

[Anonymous]

I condsidered this, but for other items on the page, they need to be shown as negatives, so ABS isnt the right solution for me on this.

[kentyler]

you can use 2 columns, one that shows positive, one that shows negative... then insert the positive column only for this graphic.

[Anonymous]

Im not sure what you mean sorry?

[kentyler]

you can have the same number in the table in 2 columns, one with minus, one plus

each graphic on the report has its own list of columns it displays. where you need to display the minus numbers, use the column with the minus version of the number