Forum Discussion
Add more values
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.
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
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
3 Replies
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
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 belowI 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'?
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