Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi, need some help on what I am doing wrong here.
The end-goal I wish to achive is a distribution curve combined with histogram.
I have been looking into the use of density in deneb but do not seem to get it right.
Code below
{
"data": {"name": "dataset"},
"layer": [
{
"description": "Histogram Bars",
"mark": {
"type": "bar",
"color": "#7DA7D9",
"tooltip": true
},
"encoding": {
"x": {
"bin": {"maxbins": 40},
"field": "Diameter",
"type": "quantitative",
"scale": {
"domain": [7.82, 7.87]
},
"axis": true,
"title": ""
},
"y": {
"aggregate": "count",
"type": "quantitative",
"axis": {"labels": false},
"title": "Count"
}
}
},
{
"description": "Histogram line",
"transform": [
{
"density": "Diameter",
"bandwidth": 0.3
}
],
"mark": {
"type": "line",
"color": "#931313",
"strokeWidth": 2
},
"encoding": {
"x": {
"field": "value",
"type": "quantitative"
},
"y": {
"field": "density",
"type": "quantitative"
}
}
}
],
"resolve": {
"scale": {"y": "independent"}
}
}
Any ideas where the problem is?
Solved! Go to Solution.
@KerKol, I adjusted the bandwith to match the standard deviation for the data sample used and got the following result.
@KerKol wrote:sounds like you may have found the issue, the above curve looks about right.
You have the Y aggregated as a count for your bars, but perhaps not for your line. What happens if you adjust the aggregation?
For the y-axis of the bars I use the aggregate: "count" and for y-axis I use "field": "density".
I am curious about what you mean by "adjust the aggregation".
The code works for me on my own data. What happens when you set resolve to dependent?
And remove the domain scale?
Proud to be a Super User!
@KerKol thanks for your suggestions but it did not help...
When I set to dependent it moves sligthly along the x-axis.
When I also remove the domain scale the bar streches out along the x-axis. In both cases the line is still not changing.
How about the "x": {"field" : "value"}... What is really inside "value", how can its content be verified or changed?
I tried changing the bandwith since Diameter has several decimals and started to get some effect..
sounds like you may have found the issue, the above curve looks about right.
You have the Y aggregated as a count for your bars, but perhaps not for your line. What happens if you adjust the aggregation?
Proud to be a Super User!
@KerKol, I adjusted the bandwith to match the standard deviation for the data sample used and got the following result.
@KerKol wrote:sounds like you may have found the issue, the above curve looks about right.
You have the Y aggregated as a count for your bars, but perhaps not for your line. What happens if you adjust the aggregation?
For the y-axis of the bars I use the aggregate: "count" and for y-axis I use "field": "density".
I am curious about what you mean by "adjust the aggregation".
Привет, мне так же интересна эта тема. Разместите полный код JSON, спасибо!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.