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!
Scatter plot of Standard deviation adding legend filter
Hi! I am attempting to plot test data for numerous samples. I am trying to plot standard deviation of a certain value vs another field and add the test sample to the legend, so I can filter out the samples. When I add the the sample test to the Legend it plots the standard deviation as all zeros. I have confirmed this is not the case. Any suggerstions? I've tried scatter plots and line plots.
Matrix Table with multiple layers breakdown
Hello guys, I have a question that is challenging me and I am struggling to find the write way to visualize it in a matrix table. I have a table as below and I want to create a matrix table where It will show me the headers as the first row and then the breakdown will be Project name, WBSE code, contract number however The key question is how would I make the project name row shows the key numbers and then the wbse row shows only the values set to it without repeating the values above and similarily the contract number values while wbse and contract values will sum to the initial project name row values. Is that possible? Project Name XYZ Location ERP Number Money Allocated Money Spent Money Saved Actuals Total Budget New Total New Budget Department 2 Contract price Project 1 Calgary ZH-000123 $ 50,000 $ 750,000 $ 25,000 $ 5,000 $ 830,000 $ 792,500 $ 150,000 $ 280,000 $ 10,000 Pro - 1 - WBSE $ 25,000 $ - $ 25,000 $ 5,000 $ 55,000 $ 42,500 $ 25,000 $ 30,000 $ 10,000 Contract 1 $ - Contract 2 $ 10,000 Pro 2 - WBSE 2 $ 25,000 $ 750,000 $ - $ - $ 775,000 $ 750,000 $ 125,000 $ 250,000 $ - Contract 3 $ -
How to get a column with 0 value inside the table
Anonymous Under Column Incident Priority, there are mainly four values, 1-Critical, 2-High, 3-Moderate, 4-Low There are no critical incidents reported for the selected period. And hence when I drag this column into the table, it simply doesn't show 1-Critical. However, the client want to see all priorities regardless there is any incidents reported or not. I tried selecting option 'Show Items with no data' but that doesn't work. Does someone know any other option?
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.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
