Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 pl...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    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's avatar
    PhilipTreacy
    4 years ago

    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

     

PhilipTreacy's avatar
PhilipTreacy
Super User
4 years ago

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