When building a Deneb custom visual for a client I came across a scenario whereby the currency within the visual showed dollars in Bing browsers but British pounds in other browsers, despite the core visuals displaying dollars across all browsers.
Thanks to a little help from DMP, this was resolved by using pbiFormat and manually specifying a locale in the options parameter
"text": {
"field": "value",
"aggregate": "sum",
"type": "quantitative",
"format" : "$##0,.0k'",
"formatType" : "pbiFormat",
"options" : {"cultureSelector": "en-US"}
}
I also needed to add additional values to the tooltips, which can be done in the encoding block of the Mark.
Each tooltip line can have a different display name and format.
"encoding: {
"tooltip": [
{
"field": "cat",
"type": "nominal",
"title": "Category"
},
{
"field": "value",
"type": "quantitative",
"title": "Value",
"format": ".3f"
},
{
"field": "Date",
"type": "temporal",
"timeUnit" : "yearmonth",
"title": "Event",
"format": "%B of %Y"
}
]
}
Here shows an example of a default tooltip enabled within Deneb
"mark": {
"type": "rect",
"tooltip": true
},
And here shows a formatted tooltip
"mark": {
"type": "rect",
"tooltip": true
},
"encoding": {
"tooltip": [
{
"field": "State",
"type": "ordinal",
"title": "State"
},
{
"field": "Month",
"type": "ordinal",
"title": "Month"
},
{
"field": "Value",
"type": "quantitative",
"title": "No. of Marriages",
"format": ",.2r"
},
{
"field": "State Value",
"type": "quantitative",
"title": "Proportion to Max State Value",
"format": ".2%"
}
],
...
}
More formatting options can be found here:
Hello, Kerry,
I’m new to Deneb and I have a question that I don’t know how to solve.
I have a line chart made up of 2 layers.
The first layer shows the evolution of the market index.
The second layer shows the evolution of the price of one or more stocks that I select in a slicer.
Objective: to create a single tooltip that shows something like:
Date: 2024/01/01
Index: 1500
IBM: 120.34
AAPL: 500.55
MSFT: 320.55
This is if I had selected IBM, AAPL and MSFT.
If I had selected more or fewer companies, I would have had to show the value of each of the selected companies.
Could you help me on this?
Thank you so much.
Joao Monteiro