show negative data as dash (-) and plot at 0 in line chart power bi

[Anonymous]

Hi, 

I want to show the neagtive data as dash ("-") and it should be plotted at zero in line chart. When I hover over the line, negative data should be shown as dash (-) in tooltip. How can I do this? right now what happens is, I could convert negative to dash using measure but then it is not displayed on the chart.

Measure I created is:

TotalQuantity = IF(CALCULATE(SUM(Table[Quantity]))<=0,"-",CALCULATE(SUM(Table[Quantity])))

Regards,

Janki

[kcantor]

@Anonymous 

Make sure the visual has "Show Items with No Data" marked. Otherwise, the visual will hide rows where there is no data. 

[Anonymous]

@kcantor ,

Thank you for your reply. however, I am not able to find this option in measure. Does this option also come when there is a measure?

Regards,

Janki

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

After my research, I'm afraid that it difficult to achieve in power bi for now.

Text value couldn't display in line chart and you want show (-) in tooltip.

If you could try use tooltips based on report pages, use TotalQuantity = IF(CALCULATE(SUM(Table[Quantity]))<=0,"-",CALCULATE(SUM(Table[Quantity]))) for tooltip and use new TotalQuantity = IF(CALCULATE(SUM(Table[Quantity]))<=0,0,CALCULATE(SUM(Table[Quantity]))) for visual value.

https://docs.microsoft.com/en-us/power-bi/desktop-tooltips

Best Regards,

Lin