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!
Datamodeling in PowerBI - Relation on different Product ID Patterns
Hello, Need some assistance with Datamodeling in PowerBI Image there are table with Product ID and Profit from different countrys. The Product ID Pattern in each table is different but contains the same number, like GB_2323GR F2323 D-2323 How could i map (create a relation) this tables with the product ID 2323 in this example and compare the profits in a report?Need help for a Visualization and Associated Data Modelling
Hi all, I am currently working on a time series data with the following structure: Timestamp - ID - EVENT-TYPE EVENT-TYPE is a column used to track entries and exits and is mapped to a column with +1/-1 as values, with +1 for entry and -1 for exit. Timestamps are Hourly, Non-Unique and Irregular (There can be multiple entries and exits in an hour, and no timestamps for time periods with zero footfall, usually on weekends and during night time) I am currently using a cumulative sum measure on this EVENT-TYPE column to visualize the total occupancy at any given time,and it's working fine. But I also want to allow my users to select any subset of the ID's and shift their in/out times by a certain amount and then see what impact it has on the overall occupancy. I am at my wit's end on how to figure this out, especially as I am not that experienced with the whole DAX/M/PowerBI ecosystem and am really struggling on how to do this. I would really appreciate if someone could show me how to do this in PowerBI. Please also let me know If I have missed any crucial details, or If I am asking this in the wrong section.
