No scroll capability in Deneb Gantt visualztion
Greetings. Have a use case for a Gantt like visualization. Landed on the Gantt rendering in the Deneb visual provided by David on his Github repoistory for Showcase Samples. Great documentation, easy to configure and get something stood up. I'm being stumped though on how to get the scroll bars to display on the visual. I've gone into the Format editor and enabled the scroll bars to be visible when editing. I can see them inside the editor. However, when I render the visual there's nothing there. Below is a screenshot of the settings. I went throgh the Vega documentation searching on the keywork "Scroll" without any luck. Any ideas on what is probably a simple thing I am missing? TIA. dm-p
Deneb Graph/Chart Issue: No Data Displayed in Embedded Power BI Report
I have tried both the standard and standalone versions of Deneb, but I keep encountering an issue where the data does not display in the chart, such as the bars in my simple bar chart in my Power Embedded Report used in React. Everything else in my Power Embedded Report functions correctly except for the Deneb chart. This leads me to believe that Deneb is either misconfigured, there is a glitch, or the dataset I am using is too large. However, the Deneb chart works properly when viewing the report directly on the Power BI app website. But when I try loading it on my domain using powerbi-client-react, it does not show any bars (data); it only displays an empty chart with labels on the x-axis. Yes, the data does appear in the table when I right-click the chart and select "View Table," so the data is there and visible. I have also tried both SVG and canvas rendering methods, but neither made a difference. No, there are no errors in my console, and Deneb is loading, showing me the version and everything, so it should work, but it does load in any data. Here is the code I am using in my deneb-chart: Specification: { "data": [{"name": "dataset"}], "scales": [ { "name": "xscale", "type": "band", "domain": { "data": "dataset", "field": "productname" }, "range": "width", "padding": 0.1, "round": true }, { "name": "yscale", "domain": { "data": "dataset", "field": "Sum of total_sold" }, "nice": true, "range": "height" } ], "axes": [ { "orient": "bottom", "scale": "xscale", "title": "productname", "labelAngle": -90, "labelAlign": "right", "labelBaseline": "middle" }, { "scale": "yscale", "orient": "left", "title": "Sum of total_sold", "tickCount": 5 } ], "marks": [ { "type": "rect", "from": {"data": "dataset"}, "encode": { "enter": { "x": { "scale": "xscale", "field": "productname" }, "width": {"value": 5}, "y": { "scale": "yscale", "field": "Sum of total_sold" }, "y2": { "scale": "yscale", "value": 0 } } } } ] } Config: { "autosize": { "contains": "padding", "type": "fit" } } Here is how it should look like (what it looks like viewing it in the powerbi app website): And this is how it looks using power bi embedded in my react project: And the weird thing is, it worked like the first time using the chart but after a while it went to 50/50 when loading in the embedded report and now it never works.
Deneb Vega - Gradient based on values of a specific column instead of fixed offsets
Hi everyone! I'm trying to create an area chart with gradient on Deneb with Vega. The idea is to set the colors of the gradient based on the values of my column called "percentage_score". This particular column have values varying from 0.0 to 100.0. If the value of the "percentage_score" in a particular month is bettween 0.0 and 50.0 i want the area to be red, from 50 it should start to become yellow and only become green if gets to 100.0. Here is what I got so far: As you can see its not correct because it should be green only if the value is 100.0. I'm not being able to find a way to make the gradient colors behave based on my "percentage_score" column. Here is a piece of my dataset: There is a way to bring the "percentage_score" to the offset values? For now the colors offset are behaving based on the area chart instead of the scores: "marks": [ { "name": "layer_0_layer_0_marks", "type": "area", "style": ["area"], "sort": {"field": "month_order_fy", "order": "ascending"}, "from": {"data": "data_1"}, "encode": { "update": { "opacity": {"value": 1}, "orient": {"value": "vertical"}, "fill": { "value": { "x1": 1, "y1": 1, "gradient": "linear", "stops": [ {"offset": 0, "color": "#ff1414"}, {"offset": 0.5, "color": "#ffdf48"}, {"offset": 1, "color": "#00FFCD"} ] } }, "description": { "signal": "\"Month-Year: \" + (isValid(datum[\"Month-Year\"]) ? datum[\"Month-Year\"] : \"\"+datum[\"Month-Year\"]) + \"; percentage_score: \" + (format(datum[\"percentage_score\"], \"\"))" }, "x": {"scale": "x", "field": "Month-Year", "band": 0.5}, "y": {"scale": "y", "field": "percentage_score_end"}, "y2": {"scale": "y", "field": "percentage_score_start"}, "defined": { "signal": "isValid(datum[\"percentage_score\"]) && isFinite(+datum[\"percentage_score\"])" } } } }
Deneb - measure totals not showing correct value
Hi, I have an issue with a deneb visual which is not showing the measure values properly. It calculates the rows seperately split by descriptions and then adds them together which is a different out come. Example: This is how it should be: ID Count hours Total Units Out come 1 10 92 9.20 What happens is: ID Count hours Total Units Out come 1 5 47 9.4 1 8 45 5.625 this totals 15.025 It counts some hours double as it considers the description (there are 4 descriptions). So you can have as 2 descriptions in 1 hour, so it doesn't count it as 1 but as 2.... When I remove "Description" from the visual values, the measure shows correctly, but I need the "Description" so removing it is not an option. To fix this I wanted to use transform, but this allows me only to use in on one measure and not on two... The below doesn't work. "transform": [ { "aggregate": [ { "op": "sum", "field": "Count of Hours", "as": "totalHours" } ], "groupby": ["ID", "Other ID"] } ], "transform": [ { "aggregate": [ { "op": "sum", "field": "Total Units", "as": "totalUnits" } ], "groupby": ["ID", "Other ID"] } ] With the standard power bi visuals I don't have this problem... but those limit me with the visual I want to create If somebody knows what can be done to fix this or has another way to solve this issue that would realy be appriciated. Thanks in advance.Deneb - How to add measures on another dataset
Hi, I want to replicate the sunburst example from Vega on my PBI here: https://vega.github.io/vega/examples/sunburst/ But, my values are not in a table, they are measures. So, I need to combine them on a hard-coded table and I'm getting this situation: Deneb is importing all measures as a table, like this: But, I need to create a dataset on Deneb like this: Any ideas on how I can do this "merge"? I think that he is not getting the values because they are on another table, but I also tried methods to do a lookup or transform it in a signal but I was unsuccessful in both cases.Deneb Dashed Line Chart
I am trying to create a dashed line chart but the lines remain solid in the plot area. Legend looks good. Any help would be appreciated. I am using sample stocks data here. Below is my code { "config": {"view": {"continuousWidth": 400, "continuousHeight": 300}}, "data": {"name": "dataset"}, "mark": "line", "encoding": { "color": {"field": "symbol", "type": "nominal"}, "strokeDash": {"field": "symbol", "type": "nominal"}, "x": {"field": "date", "type": "temporal"}, "y": {"field": "price", "type": "quantitative"} } } And below is what I am getting This is what I am looking for
