Forum Discussion
Deneb Card containing Text + Bar Chart
Hello,
I'm trying to create a card using Deneb, the card should contain a Measure representing total revenue added as Text, and below it a bar chart that breaks the revenue by month.
I have created the bar chart with no problem, but when I add the Text Mark and add the measure to it, it is added to the chart as data points (which is not what I want)
This is my code:
{
"data": {"name": "dataset"},
"layer": [
{
"mark": {
"type": "bar",
"tooltip": true
},
"encoding": {
"x": {
"field": "Year Month short",
"type": "nominal",
"axis": null
},
"y": {
"field": "Revenue",
"type": "quantitative",
"title": null,
"axis": null
},
"color": {"value": "gray"}
}
}
]
}And this is the result
Desired result
Your help is so much appreciated.
Best regards,
Simon
I found the solution, it was very simple actually
"encoding": { "text": { "aggregate": "sum", "field": "Revenue", "type": "quantitative", "format": "#,##,,.00M;(#,##,,.00M)", "formatType": "pbiFormat" } }It was this part of the code that aggregated the data points:
"aggregate": "sum"
2 Replies
- y5famfnatuduResolver I
A sample PBIX file can be found here:
https://cloud.degoo.com/share/OFPTR5znFMEcezYqdXK_RQ- y5famfnatuduResolver I
I found the solution, it was very simple actually
"encoding": { "text": { "aggregate": "sum", "field": "Revenue", "type": "quantitative", "format": "#,##,,.00M;(#,##,,.00M)", "formatType": "pbiFormat" } }It was this part of the code that aggregated the data points:
"aggregate": "sum"