Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Happy new year to everyone!!
I am following How to Fix Measure totals with Deneb , by Gregg from Enterprise DNA. I have followed this tutorial the orignal blog that the video is based on vega-lite-table-using-text-marks and another solution I found via stackover flow.
I run into the same issue with all 3 versions. I have one row data that has all the values for each column sat on top of each other.
I am passing 3 fields Year & Month are both dimensions and Revenue is a measure.
here is my code.
thanks for all help
{
"height": {"Step": 50},
"data": {"name": "dataset"},
"layer": [
{
"transform": [
{
"window": [
{
"op": "row_number",
"as": "row_num"
}
]
},
{
"calculate": "format(datum.Revenue,'.1f')",
"as": "Revenue"
},
{
"fold": [
"Revenue",
"FiscalYear",
"Month"
]
}
],
"mark": "text",
"encoding": {
"y": {
"field": "row_num",
"type": "ordinal",
"axis": {
"grid": true,
"tickBand": "extent",
"title": false,
"labels": false
}
},
"text": {
"field": "value",
"type": "nominal"
},
"x": {
"field": "key",
"type": "nominal",
"axis": {
"orient": "top",
"labelAngle": 0,
"title": null,
"domain": true,
"ticks": false,
"grid": false,
"tickBand": "extent"
},
"scale": {"padding": 15}
}
},
"config": {
"view": {"stroke": null}
}
},
{
"transform": [
{
"window": [
{
"op": "row_number",
"as": "row_num"
}
]
},
{
"fold": [
"Revenue",
"FiscalYear",
"Month"
]
},
{
"filter": "isFinite(datum.Value)"
}
],
"mark": {
"type": "text",
"color": "firebrick",
"align": "center",
"y": -25
},
"encoding": {
"x": {
"field": "key",
"axis": {"orient": "top"}
},
"text": {
"aggregate": "sum",
"field": "value",
"impute": {"value": null},
"format": ",.2f"
}
}
}
]
}
Solved! Go to Solution.
@jasemilly I'm not sure this is the problem but you have "Step" instead of "step" in your "height" property at the top. I attached the JSON template below. It is also available on MicrosoftHatesGreg github repository. Also the original PBIX file.
Thank you, I copied the visual for each of my different tests, I went over every line so many times apart from the first one! Don't know weather to laugh or cry ! thanks again.
@jasemilly Trust me, I've been there! Sometimes it just takes another pair of eyes!
@jasemilly I'm not sure this is the problem but you have "Step" instead of "step" in your "height" property at the top. I attached the JSON template below. It is also available on MicrosoftHatesGreg github repository. Also the original PBIX file.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |