Forum Discussion
Deneb Line Chart using "repeat"
Hi everyone,
I am trying to make a multiple views line chart in @deneb. Its a replication of what Power BI guy made in this video.(link attached at the end). My line chart however, has two scenarios: Act and Bud. I was able to get those. However, I want budget line to be a dotted line and I am not able to get it. Could you please help with it?
Power BI file and Code attached below:
What I can do so far:
Power BI link:
https://drive.google.com/file/d/1Eghfv1IYX4zzcsIvXT7emUrHbN41EaWN/view?usp=sharing
Deneb Code:
{
"title": {
"anchor": "middle",
"align": "center",
"offset": 10,
"text": "Ratio Analysis",
"font": "Segoe UI",
"fontSize": 16,
"fontWeight": "bold",
"fontStyle": "normal",
"subtitle": "Monthly Comparision",
"subtitleFontSize": 12,
"subtitleFontStyle": "italic"
},
"data": {"name": "dataset"},
"repeat": [
"Bonus T",
"Pts Rolling T",
"Total Pts by GW T"
],
"columns": 1,
"spec": {
"mark": "trail",
"encoding": {
"x": {
"field": "Round",
"type": "ordinal",
"title": null
},
"y": {
"field": {"repeat": "repeat"},
"type": "quantitative",
"formatType": "pbiFormat",
"format": "#.00%"
},
"color": {
"field": "Scenario",
"type": "nominal",
"scale": {
"range": ["black", "gray"]
}
},
"tooltip": [
{
"field": "Round",
"type": "ordinal"
},
{
"field": {"repeat": "repeat"},
"type": "quantitative",
"formatType": "pbiFormat",
"format": "#.00%"
}
]
}
},
"resolve": {
"scale": {
"x": "independent",
"size": "independent"
}
}
}
Power BI guy Youtube link:
https://www.youtube.com/watch?v=I6FZYTSKI6Y&list=PL6oIJxyQvMGTxh4tREeKflcKVlOfGdyim&index=2
1 Reply
- v-jianboli-msftCommunity Support
Hi Anonymous ,
Maybe you can use the
layeroperator.Sometimes, it’s useful to superimpose one chart on top of another. You can accomplish this by using the
layeroperator. This operator is one of Vega-Lite’s view composition operators. To define a layered chart, put multiple specifications into an array under thelayerproperty.For more details, refer to:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.