Gauge does not show correctly with Negative values

[mikelee1701]

Hi All,

Can someone help me suggest a away around this?

I am trying to get my guages to fill to the left from ceneter if the value is negative, and fill to the right when the value is positive.

However, i'm getting this:

My guage fill is always filling from the bottom left to right.

(The numbers are correct)

Here are my guage axis settings:

If not, any other visuals I can download to try?

Thanks in advance!

Mike

[DataZoe · Accepted solution]

@mikelee1701 I also don't think this is possible.

As an alternative, you could use a stacked bar chart:

PBIX here: https://github.com/DataZoe/PBIX/blob/master/Bar%20Guage.pbix 

[mikelee1701]

This works... would have still preferred the guages, but at least I don't get questions on why it looked funny....

Thanks!

[Greg_Deckler]

@mikelee1701 - Well, you can probably get one or the other. You could get it to fill if you made the measure IF([Measure]<0,1-[Measure],[Measure]) but then you wouldn't get the right number displayed.

[amitchandak]

@mikelee1701 , I doubt that is possible