Visualisation (Slicer and Button Slicer)
Hi everyone, I hope you all have a nice day. I want to ask (pictures attached), I gave an example of me using visualisation of "Button Slicer (Top)" and "Slicer (Bottom)" in the picture, I have a table where I have Reporting Date column then I make custom column for the quarters and months. The "Year" in the slicer is from Reporting Date hieararchy (Year), but the quarter and month in the slicer, they both are custom column that I made from the Reporting Date column (so they are not the hieararchy of "Reporting Date"). My questions (I don't mind if you answer with "Slicer" visualisation or "Button Slicer" visualisation): In Picture 1, If I select Q1 and it turns grey, how do the visualisation slicer for months turns black (for Jan, Feb, Mar) without me selecting the Quarter slicer? In Picture 2, If I select any month (for example: Aug) and it turns black, how do the visualisation slicer for quarter turns grey (Q2) without me selecting the Quarter slicer? In Picture 3, If I select Year "2025" and it turns black, how do the visualisation slicer for quarter and months also turns black without me selecting Quarter and Month slicer? Please kindly help me answer my questions. Thank you in advance. God bless. 😊🙏Custom Funnel with Category Splits?
Hi all, I am trying to build a custom funnel chart that looks something like this: I have two general questions, and then I will get into the nitty gritty of what I've built so far: 1. Is there a way to split each funnel level into categories like this? 2. Is there a way to show the step by step conversion rates without the user having to hover over the level? Into my data: Each of my definitions for sales funnel stages exists in a different table, so I created a measure for each with the filters necessary to get the right quantities. I then built a date bridge table so I can use one slicer on all the dates I need (traffic date, lead created date, etc). Within my Traffic table, I have a column called "Default channel grouping" that defines all of the categories I want my funnel to be split into. In my other 3 tables, however, there is a column called "referral source" with urls that I will have to manually group and categorize as social, paid, etc. to match the default channel grouping from the Traffic table. Once I create channel groups with the "referral source" column in my 3 tables, how would I go about creating a bridge table so that I can use one slicer on the entire funnel for "Default channel grouping"? And how would I create the splits on each funnel level by those categories? This is what my DAX looks like for each sales level. It is pretty much the same for each, with different filters and table names depending on how we define the level. My Traffic table does not have a relationship to any of the other tables as we do not have a way to attribute traffic to leads until they enter our sales funnel (e.g. give us contact info), so the Traffic table has a many to one relationship with the Date Table I created. Each of the other 3 tables also has an inactive relationship to the Date Table by created date that I activate with my measures (USERELATIONSHIP). The other 3 tables (Lead, Opportunity, Account) have a one to one relationship on "Id". I hope that helps explain my data structure but happy to help explain in further detail. Thank you in advance for any help!
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!
[Error] Couldn't load the data for this visual in DirectQuery mode
Hello, we are currently encountering an issue regarding data in the "Direct Query" mode: Within the Slicer: If it's single selection, the visualization chart encounters the following error: [OLE DB or ODBC error: [Expression.Error] Unable to fold the expression to the data source, please try a simpler expression] (as shown in picture below). If it's multi-selection, the visualization chart displays correctly. May I ask what could be the cause of this issue?Filter Columns (Text) by Slicer
Hey guys I have a table with multiple categories and I need to filter them in the visual by slicer. The table should be in one visual with all the data. And if a filter is selected it should filter the columns not the rows/values. Filter Nutzung (filter rows): "Nutzung" that need to be filtered: easy with a typical slicer with the values from the original table. Filter Gewerk (type of work) - Filter columns: there starts the problem there are multiple columns with the same type of work (red is one and green). The prefix to each name in each column is red = "Heizung" = "HEI". For green = "Kälte" = "KAE" Filter Systeme - Filter columns: I assume this would be the same workflow as "Filter Gewerke". I know there could be a workaround on this one and this is not the core of relational databases/modelling with primary keys. I hope you know what my problem/goal is, otherwise let me know - thanks a lot in advance! beste regards, MrNeverland
Sparkline for Last 4 quarters but Columns values filtered for selected Quarter using Slicer.
Hi, I am having trouble charting a Sparkline with SVG format for last 4 Quarters. All columns are in single table "Master". Requirement : 1) I have a slicer with Date . When filtered for Current Quarter , all columns in the table should filter for current quarter but Sparkline should display for 4 Quarter from selected Quarter. 2) Sparkline should be displayed for last 4 Quarters. - Issue i have . Measure "Sparkline" is the actual SVG Sparkiline and "Trend" Measure is something i was trying it out which wasnt working. Attached the PBIX file and input excel file . I have posted similar issue earlier but nothing got it solved and also similar threads are also still open . Experts please pitch in. https://drive.google.com/drive/folders/1UwOhCvqex3Cmok7SEcdFDKwM6RW7Ks6m?usp=sharing tamerj1 @v-yohua-msft Attached PBIX file and input file.
Need help in creating a histogram from a measure
Hello! I have an [Age] measure that calculates the age of active employees given a chosen year. I'm attempting to create a histogram to show the distribution of the ages of active employees given a chosen year using this measure. Is this possible? Below is the Age measure formula used: Age = VAR _selyear = MAX(_Calendar[Year]) VAR _age = CALCULATE( DATEDIFF(SELECTEDVALUE(hr_coredata[DOB]),DATE(_selyear, 12, 31 ), YEAR ), ALL(_Calendar),_Calendar[Year]<=_selyear) RETURN _age I tried creating the histogram using a calculated column but since it's a calculated column, ages will not be updated if I select other years. I tried categorizing the ages of all active employees given a selected year using the formula below but I'm not really sure how I can used this in creating my histogram: Age Category = VAR _age = [Age] // Assuming [Age] is the name of your existing Age measure RETURN SWITCH( TRUE(), _age < 25, "Under 25", _age >= 25 && _age <= 34, "25-34", _age >= 35 && _age <= 44, "35-44", _age >= 45 && _age <= 54, "45-54", _age >= 55, "55+" ) Please help! Thank you so much.
Modifying chart filtering behavior
Hi When one clicks on one of the bars in the bar graph, it dims other bars in the chart and highlights the selection. How can we modify this so that once the user clicks that particular bar on the bar chart, only that bar chart remains present. I am aware that we can use 'Edit Interactions' to enable filtering instead of highlighting but this applies to other visuals. How can i achieve this behavior within the primary chart itself.
