Questions tagged [deneb]

For questions about the Deneb custom visual in Power BI. Deneb allows you to create Power BI visuals using the Vega-lite (default) or Vega language. For code questions, include [vega-lite] or [vega] tags on your question.

What is Deneb?

Microsoft Power BI is a data visualization tool. "Power BI comes with many out-of-the-box visuals that are available in the visualization pane of both Power BI Desktop and Power BI service. Many more certified Power BI visuals are available from the Microsoft AppSource."2

Deneb is one such certified custom visual on AppSource. You can download a sample Deneb Power BI file there. Additional documentation on Deneb can be found on GitHub.

Why Deneb?

The amount of customization of the out-of-the-box visuals in Power BI is limited. If you want to do more customization of fonts, colors, formatting, or marks than the visual allows, you have to write your own custom code. Writing custom visualizations for Power BI is hard. They are usually written in D3 using Visual Studio, which is beyond the ability of most data and business analysts.

Deneb solves this problem by allowing you to enter Vega-lite or Vega code from within the Power BI visual. Vega-lite is still code, but significantly more accessible than D3. You can take a sample from the Vega-lite Example Gallery and easily implement it in Power BI even without understanding how the code works! With minimal learning, you can tweak the samples and eventually write your own complex visualizations.

Vega visualizations are highly customizable and interactive, and Deneb allows full integration and cross-filtering with other Power BI visuals. Prior to Deneb, it was difficult to create flashy infographics and high quality visuals in Power BI, especially compared with other tools such as Tableau. With Deneb, Power BI developers can now create beautiful visualizations too.

Finally, Vega is versatile. Vega code can be used not only in Power BI, but also in websites from JavaScript and in Python using Altair. You can develop one custom Vega visual and then use it many different places. Python and R visuals can be used in Power BI, but they are rendered as static images and do not allow the interaction and cross-filtering that Deneb allows. R and Python have huge problems with library versions in Power BI, while Deneb has the Vega libraries self-contained.

112 questions
0
votes
1 answer

Table visual with customized grid layout in Deneb (Vega-Lite)

I am trying to implement a custom PowerBI reporting visual for my work. Basically I need a table visual that is able to achieve a custom grid layout and I thought I'd turn to Deneb since the native matrix visual cannot achieve it. I need to be able…
Sojaboy
  • 1
  • 1
0
votes
2 answers

How to scale the indivisual bar height in Vega Lite

I want to scale the bar height according to the SUM_A + SUM_B value. In this example I would like to have the first graph to have the same height as the last one. And I would like the first bar to have the height of the sum of the height of the bars…
0
votes
0 answers

Deneb: combining Power BI tooltip with custom mouseover behavior

I'm working on a report design, which has quite specific requirements for chart behavior. Using Deneb, I've created small multiples looking like this, with bars/labels being some sort of KPI, and number below is calendar week: Using param with…
0
votes
2 answers

How to set the domain from to the sum of a field to the sum of another field?

I would like to calculate the sum of "SUM A" to set this as minimum scale value for all "X" axis. And the sum of "SUM B" to set als maximum scale for all "X" axis. I can´t get my head around how to calculate the sum of the rows and use them in the…
0
votes
1 answer

Reduce the density of axis & data labels (in sync)

Is it possible to manage density of data labels (text marks) similarly to what the labelOverlap setting does with the axis labels? Ideally, I'd like them to be in sync. { "data": {"name": "dataset"}, "encoding": { "x": { "field":…
VladB
  • 59
  • 6
0
votes
1 answer

How do I make a stacked bar graph in Vega-Lite where the bars are count but the data labels are percent?

I am trying to make a stacked bar chart in vega-lite so that I can use it with Deneb in PowerBI. In this simple example), the expected behaviour is that the X-axis should be variety, and the Y-axis should be count of site coloured by site. The text…
0
votes
0 answers

Using datum w. numerical index instead of column name

Is there any way to access a column in datum using its positional index such as datum[1] (doesn't work) instead of datum.ColumnName or datum['ColumnName']?
VladB
  • 59
  • 6
0
votes
1 answer

Show negative values in Deneb column chart in red

I've been playing around with the Deneb visual in PowerBI Desktop and (amongst many other things) have been trying to create a simple column chart that shows negative values in red and positive values in green, however can't for the life of me seem…
Ben
  • 363
  • 2
  • 4
0
votes
1 answer

Is there a method to pass the formatting selection made in the PowerBI menu to a Deneb visual?

See title, trying to pass a formatting selection (for example, percentage) to a Deneb visual instead of defining it in the vega / vega-lite JSON, and wanted to know if such a thing was possible. Right now, we are just manually changing the…
0
votes
1 answer

Set default values of brushed data on x-axis with dates

I am working with the Overview and Detail Vega-Lite sample at https://vega.github.io/vega-lite/examples/interactive_overview_detail.html I am trying to set default values for the brushed data on the Overview Chart x-axis. Open the Chart in the Vega…
TheRizza
  • 1,577
  • 1
  • 10
  • 23
0
votes
1 answer

Set domainMax to max of brushed values

I am working with the Overview and Detail Vega-Lite sample at https://vega.github.io/vega-lite/examples/interactive_overview_detail.html I would like the Detail chart to dynamically adjust the y-axis to reflect the brushed values in the Overview…
TheRizza
  • 1,577
  • 1
  • 10
  • 23
0
votes
1 answer

Deneb plot (Vega-Lite) for Power BI: How to use an free scale y-axis with facet

I am using Deneb custom visual to repeat visual for different tasks. Is it possible to only show the relevent Y-axis values. Following data is used: The following Vega-lite JSON is used: { "data": {"name": "dataset"}, "mark": { "type":…
0
votes
1 answer

Is it possible to add quantitative values to color legend in Vegalite?

I'm currently trying to create a donut chart in Vega-lite that uses Royalty as theta and Year as color, and includes both values in the legend. The legend for color is working fine, but I cannot figure out how to either concatenate the theta values,…
0
votes
1 answer

Years Not Formatting to Correct Date Format

Fairly new to vega/vega-lite and javascript in general so trying my hand at this and it is not working the way I'd like. My main issue at the moment is that my years are whole numbers as primitive values. I've tried parsing them to show as temporal…
vzap
  • 1
0
votes
1 answer

Add lower and upper limit specification vertical lines on histogram with DENEB [VEGA-LITE]

Hello! I am working with data analysis on Power BI. Since recently the platform removed the Histogram Chart I am trying to work with Deneb, a custom visual based on Vega-lite. I would like to build a histogram, with mean, lower specification limit…