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

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

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors