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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

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.

Top Solution Authors