Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a tooltip page which displays the time of an event when it is hovered over on a line chart - this works well. The field being used in the card on the tooltip is a Time Only type and has a summation method of "earliest".
Line Chart:
Tooltip page with the top card selected:
The problem is if there is no data for the day (axis value on line chart) then the tooltip displays "(Blank)". I would like to change this to the string "Not Detected".
I have tried creating a measure:
Solved! Go to Solution.
Perhaps try one of these:
event1Time tooltip =
var result = MIN(event1table[eventTime]) & ""
return
if(
result = BLANK(),
"Not Detected",
result
)
event1Time tooltip =
var result = MIN(event1table[eventTime]) & ""
return
if(
result = "#,0.00",
"Not Detected",
result
)
Another solution that I just found which worked, reformatting the output:
event1Time tooltip =
var result = MIN(event1table[eventTime])
return
if(
result = BLANK(),
"No Data",
FORMAT(result, "h:nn AM/PM")
)
Perhaps try one of these:
event1Time tooltip =
var result = MIN(event1table[eventTime]) & ""
return
if(
result = BLANK(),
"Not Detected",
result
)
event1Time tooltip =
var result = MIN(event1table[eventTime]) & ""
return
if(
result = "#,0.00",
"Not Detected",
result
)
Thanks @Greg_Deckler , the first measure worked:
event1Time tooltip = var result = MIN(event1table[eventTime]) & "" return if( result = BLANK(), "Not Detected", result )
It now displays the time instead of the "#,0:00".
Could you help me understand what adding the & "" did to solve this? Does this force it to format result as a string?
Thanks!
@lachlanP Bingo, forces it to a string.
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |