2

I am new to using Vega-lite through Deneb in Power BI. I am creating a bubble chart as a timeline view. I included my code below. The size of the bubbles in based on value, the date is the x-axis, and the prob is the y-axis. Everything works perfectly except the tooltip. For ID#, instead of showing the number it shows "False". If I put ID# in the labels for each bubble it shows the number just fine, so I'm not sure why it's showing "False" instead of the ID number in the tooltip. Thanks!

I based my chart off this one: https://vega.github.io/vega-lite/examples/circle_natural_disasters.html

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "data": {
    "name": "dataset"
  },
  "width": 950,
  "height": 400,
  
  "encoding": {
    "x": {
      "field": "Date",
      "type": "temporal",
      "axis": {"grid": false, "format":"Q%q %Y", "title":"Date"}
    },
    "y": {
      "field": "Prob", 
      "type": "quantitative", 
      "axis": {"title": "Prob"}
    },
    "tooltip" : [
                {"field":"Title", "type": "nominal"},
                {"field":"ID#", "type":"nominal"},
                {"field":"Amount", "type": "quantitative"},
                {"field":"Description", "type":"nominal"}
                ]
  },
  
  
  "layer":[{
      "mark":{
        "type": "circle",
        "opacity": 0.8,
        "stroke": "black",
        "strokeWidth": 1
      },
      "encoding": {
          "size": {
                "field": "Amount",
                    "type": "quantitative",
                    "title": "",
                    "legend": "",
                    "scale": {"rangeMax": 5000}
                 },
              "color": {
                    "field": "Type", 
                    "type": "nominal"
           }
        }
    },
    
    
    {
      "mark":{
      "type": "text",
      "align": "left",
      "baseline": "top",
      "dx": 5,
      "limit":200,
      "angle":-25
    },
      "encoding": {
        "text":{"field":"Title", "type":"nominal"}
      }
    }
  ]
  
}

I tried putting ID# in the tooltip but instead of showing the ID#, it just shows the word "False" for ID# for all bubbles in the chart.

Davide Bacci
  • 16,647
  • 3
  • 10
  • 36
Alyssa
  • 21
  • 1
  • Can you share a sample.pbix with your data? – Davide Bacci Jul 25 '23 at 14:01
  • @DavideBacci I can't share the actual data and it doesn't have this issue with dummy data I created – Alyssa Jul 25 '23 at 15:28
  • For anyone with this issue: changing the data type fixed this problem for me! I had it stored as text because I didn't want PBI to automatically summarize it. When I changed it to a numerical data type in PBI it fixed my problem in Deneb. – Alyssa Aug 01 '23 at 17:02

1 Answers1

1

Alyssa answered this question herself:

For anyone with this issue: changing the data type fixed this problem for me! I had it stored as text because I didn't want PBI to automatically summarize it. When I changed it to a numerical data type in PBI it fixed my problem in Deneb.

APB Reports
  • 985
  • 10