Power of Deneb-Vega: The US Presidential Election Chart (chart example with JSON code)
After all the struggle with native Power BI visuals (their limitations) Deneb-Vega gives you a real power. Probably for someone who worked with JavaScript from the beginning it’s nothing special, but for a Power BI developer it’s a whole new world inside of Power BI. Highly customizable and interactive world of data visualization. I wanted to build this chart in 2020 during the US elections, but I had no tool (inside of Power BI) and knowledge (Vega) to achieve required conditional formatting and interactivity. Now I can build highly customized and highly interactive charts in Power BI. And what is great, it’s possible to publish the same chart on the web without Power BI. The charts show the elections result, but also allows a user to flip states/districts (by clicking on a gray horizontal bar) to see how different result in this state/district could affect the overall result. The chart could be very useful during the vote counting, when most results are already known, but a few states/districts are still counting the votes. But I have missed the 2020 elections and made the chart 2 years later. Well, soon it will be useful again. Also it’s a great showcase of a good data visualization and a great showcase of Deneb-Vega possibilities. Live Power BI report with the chart: https://powerofbi.org/2022/10/27/us-presidential-elections-chart/ Vega JSON code: https://github.com/avatorl/Deneb-Vega/tree/main/US%20Elections%20Chart
Adjust bar colors on the Y-axis in a horizontal bar chart
ENG Hi everyone, I’m using horizontal bar charts and have seen several tutorials showing how to turn them into funnel charts . However, when working with more than one measure on the X-axis, I’m unable to customize the colors of individual bars. I would like to suggest that Power BI allow users to customize the bar colors on the Y-axis based on the selected metric, either by function or by parameter. Does anyone know if there is currently a way to do this, or is there a workaround? If not, I’d like to put this forward as a feature request. This video shows a practical example of what I mean: https://www.youtube.com/watch?v=qAuUP191My4 Thanks! PT Olá, pessoal, Estou utilizando gráficos de barras horizontais e vi diversos tutoriais na internet mostrando como transformá-los em funis. No entanto, ao trabalhar com mais de uma medida no eixo X, percebi que não consigo customizar a cor das barras individualmente. Minha sugestão é que o Power BI permita ao usuário customizar as cores das barras no eixo Y com base na métrica selecionada, seja por função ou por parâmetro. Alguém sabe se já existe uma solução ou configuração para isso? Caso contrário, fica a sugestão de melhoria. Este vídeo mostra um exemplo prático do que quero dizer: https://www.youtube.com/watch?v=qAuUP191My4 Obrigado!Funnel chart – how to display more than one value?
ENG Hi everyone, When using the native Power BI funnel visual, we typically add the category (e.g., stages of a sales funnel) and a measure in the values field. However, I often need to display more than one value, such as the number of opportunities at each stage and the average ticket value for those opportunities. I know it’s possible to add the average ticket to the tooltip, but users often want to see both numbers directly on the visual without hovering. In horizontal bar charts, we can customize the data label to show the value and series detail, as well as adjust label positioning. I’ve tried various funnel visuals, but I would like the native funnel chart to offer more flexibility in customization, similar to other visuals that have evolved over time. Does anyone have a tip or workaround for this? If not, I’d like to submit this as a feature request. Thanks! PT Olá, pessoal, Ao trabalhar com o visual de funil nativo do Power BI, adicionamos a categoria (por exemplo, etapas do funil de vendas) e a métrica em valores. No entanto, muitas vezes preciso mostrar mais de um valor, como a quantidade de oportunidades em cada etapa e o ticket médio dessas oportunidades. Sei que é possível colocar uma segunda medida na dica de ferramenta, mas os usuários costumam querer ver ambos os números diretamente no gráfico, sem precisar passar o mouse. Em gráficos de barras horizontais conseguimos personalizar o rótulo para exibir o valor e o detalhe da série, além de ajustar a posição desses rótulos. Já testei vários visuais de funil, mas gostaria que o visual nativo oferecesse mais opções de customização, assim como acontece com outros gráficos que evoluíram ao longo do tempo. Alguém tem alguma dica ou solução alternativa? Se não houver, deixo aqui a sugestão de melhoria para futuras versões. Obrigado!
Minimum Width for Stacked Column Chart
Why is the minimum column width limited to 20 px in a stacked column chart when the X-Axis uses a dimension other than date? I've attached 2 screenshots the first one, i am able to fit over a hundred bars into a small space (first image), but if i want to use category labels the bars are super wide and I have to scroll way to the right to see everything (second image). It would be impossible for me to overstate how frustrating this is.
