Forum Discussion

ShivGC's avatar
ShivGC
Helper I
3 years ago
Solved

Deneb Visual Zooming

Hi,  I required some help with making my non-linear regression graph, zoom-able.  I am using the deneb visual app on power bi and I have managed to create a scatterplot using the X Field and Y ...
Need Help
  • ShivGC's avatar
    ShivGC
    3 years ago

    I have Figured out the solution to this and will paste the code below for anyone who would like to try mimic this.

    Essentially, you are able to make a regression graph and make it zoomable but you just have to code within the same Layer ("layer" function). Please take a look below, at the code:

    {
  "data": {"name": "dataset"},
  "layer": [
    {
      "mark": {
        "type": "point",
        "filled": true
      },
      "encoding": {
        "x": {
          "field": "X FIELD",
          "type": "quantitative",
          "axis": {"format": "%"}
        },
        "y": {
          "field": "Y FIELD",
          "type": "quantitative",
          "axis": {"format": "%"}
        },
        "color": {
          "field": "CLIENT COLOUR FIELD - IF THIS IS NOT APPLICABLE TO YOU, PLEASE TAKE IT OUT",
          "type": "nominal",
          "legend": null,
          "scale": {
            "range": [
              "#006D9E",
              "#A6E2EF"
            ]
          }
        }
      }
    },
    {
      "mark": {
        "type": "line",
        "color": "black"
      },
      "transform": [
        {
          "regression": "Y FIELD",
          "on": "X FIELD",
          "method": "pow"
        }
      ],
      "encoding": {
        "x": {
          "field": "X FIELD",
          "type": "quantitative"
        },
        "y": {
          "field": "Y FIELD",
          "type": "quantitative"
        }
      }
    },
    {
      "transform": [
        {
          "regression": "Y FIELD",
          "on": "X FIELD",
          "params": true,
          "method": "pow"
        }
      ],
      "mark": "circle",
      "encoding": {
        "x": {
          "field": "X FIELD",
          "type": "quantitative"
        },
        "y": {
          "field": "Y FIELD",
          "type": "quantitative"
        }
      },
      "params": [
        {
          "name": "grid",
          "select": "interval",
          "bind": "scales"
        }
      ]
    }
  ]
}

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , ShivGC 

According to your description, you want to zoom in the Deneb custom visual . Sorry for i am also unfamilar for this custom visual .

As searched , it can zoom in and out by using the mouse wheel .And for the code you can refer to :
Adding Interactive Widgets To Visuals Using Deneb in Power BI | Sandeep Pawar (pawarbi.github.io)

 

And i also test in my side , this is my test data:

And we can use this code :

 

{
  "config": {"view": {"continuousWidth": 400, "continuousHeight": 300}},
  "data": {"name": "dataset"},
  "mark": "circle",
  "encoding": {
    "x": {"type": "quantitative", "field": "X FIELD"},
    "y": {"type": "quantitative", "field": "Y FIELD"}
  },
  "height": 200,
  "selection": {
    "selector016": {
      "type": "interval",
      "bind": "scales",
      "encodings": ["x", "y"]
    }
  },
  "title": "Sactterplot with Widget",
  "width": 100,
  "$schema": "https://vega.github.io/schema/vega-lite/v4.8.1.json"
}

 

 

 

Then we can get the result like this:

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

    • v-yueyunzh-msft's avatar
      v-yueyunzh-msft
      Community Support
      3 years ago

      HI , ShivGC 

      You can try this code if it can help you :

      {
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "data": {"url": "data/movies.json"},
  "layer": [
    {
      "mark": {"type": "point", "filled": true},
      "encoding": {
        "x": {"field": "Rotten Tomatoes Rating", "type": "quantitative"},
        "y": {"field": "IMDB Rating", "type": "quantitative"}
      },
      "selection": {
    "selector016": {
      "type": "interval",
      "bind": "scales",
      "encodings": ["x", "y"]
    }
  }
    },
    
    {
      "transform": [
        {
          "regression": "IMDB Rating",
          "on": "Rotten Tomatoes Rating",
          "params": true
        },
        {"calculate": "'R²: '+format(datum.rSquared, '.2f')", "as": "R2"}
      ],
      "mark": {
        "type": "text",
        "color": "firebrick",
        "x": "width",
        "align": "right",
        "y": -5
      },
      "encoding": {"text": {"type": "nominal", "field": "R2"}}
    }
  ]
}

       

      Vega Editor

       

       

      Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

       

      Best Regards,

      Aniya Zhang

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

      • ShivGC's avatar
        ShivGC
        Helper I
        3 years ago

        Hi, 

        Unfortunately, this is not what I am looking for. I am able to get a typical scatter plot which I am able to zoom in and out of, however, the idea is too add a non-linear regression line to the graph.

        This is done on power bi:

         

        {
  "data": {"name": "dataset"},
  "params": [
    {
      "name": "grid",
      "select": "interval",
      "bind": "scales"
    }
  ],
  "mark": "circle",
  "encoding": {
    "x": {
      "field": "X Field",
      "type": "quantitative"
    },
    "y": {
      "field": "Y Field",
      "type": "quantitative"
    }
  }
}

         


        Now, the aim is to add a regression line to it, so that I can zoom into the regression line and see points a little clearer.