Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Salle
Advocate I
Advocate I

Deneb: Distribution curve on bar diagram

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.
Capture.JPG
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"}
  }
}

 

 

Salle_1-1675892826077.png

 Any ideas where the problem is?

1 ACCEPTED SOLUTION

@KerKol, I adjusted the bandwith to match the standard deviation for the data sample used and got the following result.

Salle_0-1676012680994.png

 


@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".

 

 

View solution in original post

5 REPLIES 5
KerKol
Power Participant
Power Participant

The code works for me on my own data. What happens when you set resolve to dependent?

And remove the domain scale?





Did I answer your question? Mark my post as a solution!

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..

Salle_0-1675971897333.png

 

KerKol
Power Participant
Power Participant

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?





Did I answer your question? Mark my post as a solution!

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.

Salle_0-1676012680994.png

 


@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, ัะฟะฐัะธะฑะพ!

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (25)