help requested
2 TopicsAnother Deneb query - 2 data fields on one bar chart
I have cause to render two different data fields on to the same bars in the same chart. so for instance the x axis will be date y axis should have field 'A' and field 'B' stacked on top of each other for the given date. Also both fields are grouped by another field, 'Z'. Groupings for A should be shown separately from Groupings for B in the legend, Getting A to work is simple: { "$schema": "https://vega.github.io/schema/vega-lite/v5.json", "data": { "values":[ {"A":10, "B":20, "Z":"poop", "created":"2022/01/01"}, {"A":10, "B":10, "Z":"moop", "created":"2022/01/01"}, {"A":10, "B":5, "Z":"doop", "created":"2022/01/01"}, {"A":13, "B":12, "Z":"poop", "created":"2022/02/01"}, {"A":33, "B":10, "Z":"moop", "created":"2022/02/01"}, {"A":0, "B":5, "Z":"doop", "created":"2022/02/01"}, {"A":13, "B":5, "Z":"poop", "created":"2022/03/01"}, {"A":3, "B":2, "Z":"moop", "created":"2022/03/01"}, {"A":20, "B":7, "Z":"doop", "created":"2022/03/01"} ] }, "mark": "bar", "encoding": { "x": { "timeUnit": "month", "field": "created", "type": "ordinal" }, "y": { "field":"A", "type": "quantitative" }, "color": { "field": "Z", "type": "nominal" } } } how would i go about adding the figures from 'B' onto each bar, in different colours and presented on the legend on separate rows?SolvedUse of timeline across a number of different reports
Hi All, Power BI newbie here, desperately trying to get a report I created to work alongside a timeline. i think the issue is that one report has the date (which I've used for the timeline) and the other also does, but I can't use 2 timelines. I did add in a start date, end date and week number relationship which the sheet is linked to, but it doesn't like it. Any suggestions....before I hit the wine. thanks Rachel827Views1like0Comments