The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Hi @Anonymous ,
Maybe you can use the layer
operator.
Sometimes, it’s useful to superimpose one chart on top of another. You can accomplish this by using the layer
operator. This operator is one of Vega-Lite’s view composition operators. To define a layered chart, put multiple specifications into an array under the layer
property.
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.
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |