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!
Count of Last 3 Months Unbilled outlets exclude the current Month
I have a column named "flag" in which "1" is against billed outlets and "0" is against unbilled outlets. I want to calculate the count of outlets that are unbilled from last 3 Months and exclude the current month. In full data: year_month range is January 2018 to Decemeber 2020. In Sample data provided for help: year_month range is 2020. Attached sample data image. Please guide me in using the DAX expression.
Infographic Designer - multiple measures
Hi all, I am using infographic designer to desplay three volume measure, Actual Volume, Last year Volume and Planned volume using bottles as shown in the picture. But i want is to have text displayed in each measure like if it is actuall i would have an actual value desplayed on the bottle that represent the actual (which is the orange bottle in my case) and last year value on the bottle representing last year bottle etc. Simply i want to bind each measure with text. Regards, Ermias
Formatting specific cells in a measure
Hi all, Hope you all doing great! I want to customise my report. In order to do that, I want to specifically format specific cells which contains value 0 or the value which contains highest value in a measure. I am attaching a snap below. In this example, I want to format 'new' measure in such a way that it becomes easy to distinguish highest and lowest value in a measure. Please help. Let me know if this question is not clear or incomplete. Looking forward Thanks!
