dynamic segmentation
3 TopicsGet value from card to use in other card
Good morning everyone, Currently, I have a series of data segmenters and two cards. These cards change value when the data segmenters values are changed. I need a third card that divides the values of card 1 and 2. Is this possible with DAX? Is there any way to filter in DAX using the value of the filtered columns?793Views0likes3CommentsHow to make a segmentation data data filter with data in datetime format?
Hi! I'm from Brazil and totally new to Power BI, so sorry in advance for any English mistakes or innacurate terminology. I hope I am able to make you understand the problem I'm facing. I am trying to add a segmentation data filter to my dashboard, like this one: I have a main fact table containig data from a set of telephone calls, from the project I'm working on. One of its columns is called 'data_hora', which contains the date and hour the calls were made in datetime format (dd/mm/yyyy hh:nn). It looks like this: I need to make the segmentation data filter look like this, so the user is able to select both date and time: However, when I try to add this visual and drop the data_hora column to the data field, selecting the style 'Between', the time information never shows up in the filter: > Options > Styles > 'Between' (Entre) What do I need to do in order to make the time information also be selectable along with the date?577Views0likes1CommentDynamic Segmentation of callers and calls
Hi there, I was hoping someone may be able to help with a dynamic segmentation query in Power BI. I have an activities table (SQLActivities) which contains columns called activityID and callerID. The principle of the table is that a single callerID can have multiple activityID. I'm trying to create two pie charts to show: 1) Callers grouped into buckets based on number of activities per caller, and 2) Activities grouped by the same buckets for each caller. For the second pie chart I am essentially trying to show how many activities in each caller bucket -i.e. if two callers had 11 or more activities, how many activities were actually in that bucket. I have created a table to specificy the values of the buckets - they are 1, 2, 3 - 5, 6 - 10, and 11 or more. I created the table as follows: ActivitySegments = Datatable( "Segment Key", INTEGER, "Bucket", String, "Min Activities", Integer, "Max Activities", Integer, { {1,"1",1,1}, {2,"2",2,2}, {3,"3 - 5",3,5}, {4,"6 - 10",6,10}, {5,"11 or more",11,99999999999} } ) for the first chart I've been able to create a measure to show the number of callers which fall into each bucket using the following dax: Activity Buckets - Callers = VAR Summary = SUMMARIZE ( FILTER(SQLActivities , SQLActivities [Filter Activities In Date] = 1), SQLActivities [c1_calleridid], "Bucket", SWITCH ( TRUE (), COUNTROWS ( SQLActivities ) = 1, "1", COUNTROWS ( SQLActivities ) = 2, "2", COUNTROWS ( SQLActivities ) <= 5, "3 - 5", COUNTROWS ( SQLActivities ) <= 10, "6 - 10", COUNTROWS ( SQLActivities ) > 10, "11 or more" ) ) RETURN SUMX ( Summary, IF ( [Bucket] = SELECTEDVALUE ( 'ActivitySegments'[Bucket] ), 1, 0 ) ) This seems to work well enough, but I cannot work out how to convert this to calculate the number of activities per caller bucket instead of the number of callers. The expected result would show the number of activities for callers per bucket.Solved548Views0likes1Comment