topic Re: Deneb: Fold bar, text marks don't line up correct at top af bars. in Custom Visuals Development Discussion

Deneb: Fold bar, text marks don't line up correct at top af bars.

babaci — Mon, 13 Mar 2023 21:06:09 GMT

Loc	Executed	Estimated	Proforma
A	1.193		0
A	3.894		0
A	1.255		0
A	3.044		0
A	3.310		0
A	342		0
A	1.366		0
A	805		0
A	277		0
A	873		0
B	1.051	537	0
B	2	403	0
B	442	444	0
B	898	901	0
B	888	879	0
B	1	943	0
B	1.164	1164	0
B	929	866	0
B	1.661	1663	0
B	1.263	525	0
C	298		0
C	304		0
C	1.203		0
C	703		0
C	2.166		0
C	416		0
C	289		0
C	1.466		0
C	555		0
C	699		0

Hi,

Cannot seem to get the text mark on the right position, the need to be on the correct bar.

Any ideas on how I can get this solved...struggled but couldn't get it right.

Thanks.

{ "data": {"name": "dataset"}, "transform": [ { "fold": [ "Executed", "Estimated", "Proforma" ], "as": ["MoveType", "TotalMoves"] } ], "layer": [ { "mark": { "type": "bar", "tooltip": true }, "encoding": { "y": { "field": "TotalMoves", "type": "quantitative", "axis": {"title": null} }, "x": { "field": "Loc", "type": "nominal", "sort": "descending", "axis": {"title": null} }, "color": { "field": "MoveType", "type": "nominal", "title": null, "sort": "ascending", "scale": { "range": [ "#666685", "#E3A611", "#DE6A73" ] } }, "xOffset": {"field": "MoveType", "sort": "descending"} } }, { "name": "Custom labels", "mark": { "type": "text", "color": "black", "angle": 0, "baseline": "top", "dy": -12 }, "encoding": { "text": { "field": "TotalMoves", "formatType": "pbiFormat", "format": "#0,,.00M" }, "y": { "field": "TotalMoves", "aggregate": "sum" } } } ] }

Re: Deneb: Fold bar, text marks don't line up correct at top af bars.

giammariam — Mon, 13 Mar 2023 20:47:51 GMT

Hey babaci, could you provide the column names that you have in your dataset and a few dummy rows (here's how)?

happy to help with this

Re: Deneb: Fold bar, text marks don't line up correct at top af bars.

babaci — Mon, 13 Mar 2023 21:07:17 GMT

Hi giammariam , thanks for your response. I have updated the post and added a table. Let me know if you need more info.

Re: Deneb: Fold bar, text marks don't line up correct at top af bars.

giammariam — Tue, 14 Mar 2023 00:19:43 GMT

Hey babaci, let me know if this will work.

Notes

once you bring this into deneb the pbiFormat for the labels should work
you'll want to adjust the width and height values

If this is enough to get you going, consider kudoing this reply and choosing it as the answer. If you need additional tweaks just let me know!

gist can be found here

spec:

{ "width": 700, "height": 400, "data": { "name": "dataset" }, "transform": [ { "fold": ["Executed", "Estimated", "Proforma"], "as": ["MoveType", "TotalMoves"] } ], "layer": [ { "encoding": { "y": { "field": "TotalMoves", "type": "quantitative", "aggregate": "sum", "axis": {"title": null} }, "x": { "field": "Loc", "type": "nominal", "sort": "ascending", "scale": {"padding": 0.2}, "axis": {"title": null, "labelAngle": 0} }, "xOffset": { "field": "MoveType", "sort": "descending", "scale": {"paddingInner": 0.1} } }, "layer": [ { "name": "bars", "mark": {"type": "bar", "tooltip": true}, "encoding": { "color": { "field": "MoveType", "type": "nominal", "title": null, "sort": "ascending", "scale": {"range": ["#666685", "#E3A611", "#DE6A73"]}, "legend": { "orient": "none", "direction": "horizontal", "legendX": {"expr": "width/2-125"}, "legendY": {"expr": "height+25"} } } } }, { "name": "Custom labels", "mark": { "type": "text", "color": "black", "angle": 0, "baseline": "top", "dy": -12 }, "encoding": { "text": { "field": "TotalMoves", "type": "quantitative", "aggregate": "sum", "formatType": "pbiFormat", "format": "#0,,.00M" } } } ] } ] }

Re: Deneb: Fold bar, text marks don't line up correct at top af bars.

babaci — Tue, 14 Mar 2023 08:05:32 GMT

giammariam , thank you very much!! Works perfect.