charticulator
5 Topicsdax with chARTICULATOR VISULA
for actual2 = 1.87 , target2 = 0 , the goal direction is = 1 , calculation F = deviation the result from charticulator is 142% while it should be 98.13% need to know what is the problem why charticulator does not display the right result ? KPI Achievement Per Month = VAR PreAggregateResults = SUMMARIZE( VALUES('01.00sc supplychain'[KPI]), '01.00sc supplychain'[KPI], "SingleKPIResult", VAR GoalDir = MAX('01.00sc supplychain'[Goal direction]) VAR IsCalculateSelected = CONTAINS( ALLSELECTED('02.sc slicer'), '02.sc slicer'[Slicersc], "07.calculate" ) VAR ActualMeasure = IF(IsCalculateSelected, [calc actual2], [actual 2]) VAR TargetMeasure = IF(IsCalculateSelected, [Calc Target 2], [target 2]) VAR CalcType = FIRSTNONBLANK('01.00sc supplychain'[calculation f], 1) VAR IsActualZero = ActualMeasure = 0 VAR IsTargetZero = TargetMeasure = 0 // Edge case handling for zero values VAR EdgeCaseResult = IF( AND(IsActualZero, IsTargetZero), 1, BLANK() ) // Main calculation logic VAR ResultValue = IF( NOT ISBLANK(EdgeCaseResult), EdgeCaseResult, SWITCH( CalcType, "deviation", IF( IsCalculateSelected, IF( TargetMeasure <> 0, ((1 - ((ActualMeasure - TargetMeasure) / TargetMeasure)) / (1 - [target 2])), 0 ), // When calculate is not selected SWITCH( GoalDir, 1, IF(TargetMeasure <> 1, (1 - ActualMeasure) / (1 - TargetMeasure), 0), -1, IF(TargetMeasure <> 1, 2 - ((1 - ActualMeasure) / (1 - TargetMeasure)), 0), 0, IF(TargetMeasure <> 0, 1 - ABS(ActualMeasure - TargetMeasure) / ABS(TargetMeasure), 0) ) ), "divide", IF( TargetMeasure <> 0, IF( IsCalculateSelected, (((ActualMeasure / TargetMeasure) - [target 2]) * GoalDir / [target 2]) + 1, ((ActualMeasure - TargetMeasure) * GoalDir / TargetMeasure) + 1 ), 0 ), "Doubled", IF( IsCalculateSelected, ((ActualMeasure - TargetMeasure) * GoalDir / TargetMeasure) + 1, BLANK() ), BLANK() // Default case for unknown calculation types ) ) // Ensure result is between 0 and 1.5 RETURN IF( ISBLANK(ResultValue), BLANK(), MAX(0, MIN(ResultValue, 1.5)) ) ) // Return the average of all pre-aggregated KPI results RETURN AVERAGEX( PreAggregateResults, [SingleKPIResult] )Solved386Views0likes1CommentCharticulator, text objects not working as expected for data labels
Hello, I am encountering a strange bug with charticulator when i try and place text objects. I am trying to create data labels for a simple bar chart. When I place the text mark on the page, instead of getting one text object, I get an object for every data value for that category. I created sample data to build this chart, there are 4 values for every category. In the chart below, for category "0-5k", instead of seeing the sum of those 4 values, charticulator just lists every value. I am not sure if this is a bug or something I am doing wrong. Any assistance will be appreciated.422Views0likes0CommentsHow to make line style conditions on stacked bar chart?
Hi community, Relatively new to Charticulator - it is really powerful compared to the basic visualisations found in PowerBI! I'm very close to have finalised my first Charticulator custom visual - only thing I need to do is having one of my bar blocks set as dashed instead of solid line. Do anyone know how to do that? (see picture below for reference): Thanks in advance!Custom visual made with Charticulator not respecting scale
Hi, I tried to create a custom visual via Charticulator. It's a clustered and stacked column chart. Do someone know why my visual is not respecting the scale please? Here only deep blue rectangles are resized: You can find here my power BI example and my custom visual. Thank you in advance Regards, CamilleSolved17KViews0likes17Comments