Add more values

[Anonymous]

I am new to powerbi and i am trying to show + values in the axis but im unsure who to do this, can someone help?

From the image below you can see it stops at '0m' but i need to add '1m' '2m' as plus so we can see the increase. 

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Do you have valuews for 1m and 2m?  They should automatically be plotted and the axis adjust accordingly.

But, you can set the limits on the axis manually.  Select the visual and then in Formatting, open the Y Axis and you can enter a Start value for the axis. 

Regards

Phil

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Download PBIX file with examples shown below

The entire data set is given one color so you can't have different colors for positive and negative values.

The area chart doesn't appear to properly support Conditional Formatting for Data Labels either.

You could use something else like a Column Chart and use Conditional Formatting

Regards

Phil

[Anonymous]

Thank you that did work indeed for which thank you.

I have another question im trying to show the positive values in green and the negative in red see image below

I normally do this in the 'Data Colors' tab (see below, but i dont have the option to enter my own condition, is this something we cant do becasue the graph is a 'Area Chart'?

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Do you have valuews for 1m and 2m?  They should automatically be plotted and the axis adjust accordingly.

But, you can set the limits on the axis manually.  Select the visual and then in Formatting, open the Y Axis and you can enter a Start value for the axis. 

Regards

Phil