Percentage of Growth negative values not showing

[Supipa]

Hi everyone,

How do you show negative values in the y axis? I'm trying to show the percentage of growth and when i add that column to the graph it doesn't show anything, only works in a table.

thanks in advance

[v-eqin-msft]

Hi @Supipa ,

Any updates?

Best Regards,
Eyelyn Qin

[Supipa]

Hi 

@v-eqin-msft 

Sorry that it took me so long to get back to you and thank you very much for all your help.

Basically i just created another project, recreated the calendar table and it is now working!

Not sure what was going on, tbh...

Kind Regards

[v-eqin-msft · Accepted solution]

Hi @Supipa ,

I could not reproduce your issue, everything worked on my side:

1.What's your Power BI version? Please always use the latest one.

2.Did you try to switch the table visual to other visuals instead of directly create other visuals? 

If it does not help, please share me with your pbix file after removing sensitive data.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Supipa]

Hi @v-eqin-msft ,

Thank you very much for looking into this.

This is the version I have (image below) and belive it is the latest. Will prepare a pbix file to add here. 

Thank you!

[KamilSzpyrka]

Hi Supipa,

can you please share more information about Percentage of Growth - is it a measure or a column? Can you show samples of data?

[Supipa]

Hi Kamil.

It's a measure.

Here it is how it shows on a table:

 Thank you!!

[KamilSzpyrka]

Can you share the definition of measure please (DAX formula)?

[Supipa]

sure: 

% Bets Growth = DIVIDE ([Bets Growth Difference], [PriorMonthBets])

i basically followed this:

https://www.mssqltips.com/sqlservertip/6424/calculate-percentage-growth-over-time-with-power-bi/