topic Re: Deneb Card containing Text + Bar Chart in Custom Visuals Development Discussion

Deneb Card containing Text + Bar Chart

y5famfnatudu — Tue, 28 Feb 2023 09:32:23 GMT

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

Re: Deneb Card containing Text + Bar Chart

y5famfnatudu — Tue, 28 Feb 2023 11:30:19 GMT

A sample PBIX file can be found here:
https://cloud.degoo.com/share/OFPTR5znFMEcezYqdXK_RQ

Re: Deneb Card containing Text + Bar Chart

y5famfnatudu — Wed, 01 Mar 2023 09:25:20 GMT

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"