Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to Solution.
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"
A sample PBIX file can be found here:
https://cloud.degoo.com/share/OFPTR5znFMEcezYqdXK_RQ
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"
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |