Help me create this graph
Hi, I'm trying to recreate this chart here. But I'm failing and only get this one: My summer hire column is found in my data table. I dragged it to my legends. Here's are my DAX formulas for more context: Retained 3M = VAR PeriodStart = MIN('Calendar'[Date]) VAR PeriodEnd = MAX('Calendar'[Date]) RETURN CALCULATE( COUNTROWS(Employment), Employment[Hire Date] >= PeriodStart && Employment[Hire Date] <= PeriodEnd, ( ISBLANK(Employment[Termination Date]) || Employment[Termination Date] >= EDATE(Employment[Hire Date], 3) ), CROSSFILTER('Calendar'[Date], Employment[Hire Date], None) ) Retention 3M = DIVIDE([Retained 3M], [Cohort Size], 0) Cohort Size = CALCULATE( COUNTROWS(Employment), Employment[Hire Date] >= MIN(Calendar[Date]) && Employment[Hire Date] <= MAX(Calendar[Date]) ) I created a disconnected table and create retention % as measure: Retention % = VAR SelectedPeriod = SELECTEDVALUE(RetentionAxis[Period]) RETURN SWITCH( SelectedPeriod, "3M", CALCULATE([Retention 3M]), "6M", CALCULATE([Retention 6M]), "12M", CALCULATE([Retention 12M]), "24M", CALCULATE([Retention 24M]), BLANK() ) RetentionAxis = DATATABLE( "Period", STRING, "Order", INTEGER, { {"3M", 1}, {"6M", 2}, {"12M", 3}, {"24M", 4} } ) Please help!
Improved chart reading with Dax formula
Hello everyone, For a graph, I would like the display to be more list here we have the number of value according to day. I would like it not to be displayed when there are less than 5 values per day. The aim is to have a trend. I have try with this Dax formula : // Colonne calculée NombreParJour = CALCULATE( COUNT('Issues (Central Malley – Aire B)'[Area]), ALLEXCEPT('Issues (Central Malley – Aire B)', 'Issues (Central Malley – Aire B)'[Created].[Jour]) ) // Mesure CompteurValeurFiltre = IF( MAX('Issues (Central Malley – Aire B)'[NombreParJour]) < 10, BLANK(), COUNT('Issues (Central Malley – Aire B)'[Area]) ) Can You help me ?
I can’t use measure as a chart legend to categorize the data
Hello! I have a dataset like this: Date Client Total Sales Sales Prev Diff Sales MRR Measure 2024/January A 200 200 New 2024/February A 500 -200 Lost 2023/January B 100 New 2024/January B 650 150 Reactivation 2024/February B 150 -150 Lost 2023/December E 11885 New 2024/January E 6265 11885 -10670 Reduction 2024/February E 1515 -1215 Lost 2024/March E 6270 6970 Reactivation 2024/April E 64850 6990 7880 Expansion 2024/May E 3650 14850 -11700 Reduction I have written a DAX code as a measure. The code is as follows: MRR Measure = if([firstD]=1,"New", if(and([Total Sales]>=0,[Sales Prev]=0),"Reactivation", if([Diff Sales]>=0,"Expansion", if(and([Total Sales]=0,[Sales Prev]<>0),"Lost", if([Diff Sales]<0 , "Reduction"))))) and the code for the Different Sales: Diff Sales = [total sales]-[sales prev] I want to add a bar chart based on this different sales value and the date. It gives me something like this: I want something like below, but because I have written a measure I can’t move it to the legend field in the chart. What should I do?
