charticulator
6 TopicsCreate a Custom Chart with Charticulator without any Coding
Creating a custom visual for Power BI is a need that can be addressed with different approaches. One of the easiest ways to create custom visuals is using a No code platform named Charticulator. In this session, the audience gets familiar with basic charts like the Scatter chart and Bar chart. Creating some complex charts like polar charts, Pyramid, and ranking charts will be presented. 𝙈𝙚𝙚𝙩𝙞𝙣𝙜 𝙡𝙞𝙣𝙠(𝙈𝙎 𝙏𝙚𝙖𝙢𝙨): https://bit.ly/36XTN3D 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: Farsi565Views0likes0Commentsdax 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