Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
@Anonymous
Make sure the visual has "Show Items with No Data" marked. Otherwise, the visual will hide rows where there is no data.
Proud to be a Super User!
@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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |