line charts
3 TopicsLine Chart of Bins without Calculated Columns
I have a table 't_Devices' of columns [Device ID], [Date], [Input], [Output]. With Efficiency='t_Devices'[Input]/'t_Devices'[Output], I want to create a line chart of Efficiency Bins over time. To do that, I created calculated column of [Efficiency], then dummy calculated columns of [Is Efficiency In Bin 0-50], [Is Efficiency In Bin 50-100] based on [Efficiency], then a line chart of columns [Is Efficiency In Bin 0-50], [Is Efficiency In Bin 50-100], [Is Efficiency In Bin >100] over column [Date]. I want to ask whether is there any better way to create the line chart without creating a lot of dummy Bin columns because I have many bins in my real data. Thank you very much.SolvedCreating a 3 Axis Line Chart
Hello! In the attached or below, you'll see 3 axis line chart created in excel. It's a line chart using the secondary and then overlapping another line chart on top of that. It works but is a bit sloppy. We're trying to do the same in Power BI without buying a license from a third party. Is there a way to do this using the Power BI native charts? If not, does overlapping two line charts work? Thank you so much for any help!!Solved4.4KViews0likes7CommentsERROR MESSAGE ON LINE CHART
Feedback Type: Frown (Error) Timestamp: 2024-06-14T13:58:30.7627063Z Local Time: 2024-06-14T09:58:30.7627063-04:00 Session ID: 015591fb-a2d0-4619-85fa-95be7bcb4ec6 Release: June 2024 Product Version: 2.130.754.0 (24.06) (x64) Stack Trace: Javascript:TypeError at AxisZoomSlider.getSliderOutlines (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.cartesianChart.min.js:3464:141) at Object.getRegionOutlines (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.cartesianChart.min.js:3460:38) at HtmlSubSelectionHelper.updateOutlinesFromSubSelectionElements (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:255205:130) at HtmlSubSelectionHelper.onPointerOver (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:254948:42) at HTMLDivElement.<anonymous> (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:254918:31) at HTMLDivElement.<anonymous> (https://ms-pbi.pbi.microsoft.com/minerva/scripts/powerbi.common.externals.js:8104:18) at _ZoneDelegate.invokeTask (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:140299:193) at hooked_1.invokeTask (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:469529:81) at https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:469114:63 at process (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:469096:36) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.130.754.0","ModuleName":"https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.cartesianChart.min.js","Component":"AxisZoomSlider","Error":"TypeError","MethodDef":"getSliderOutlines","ErrorOffset":"3464:141","ErrorCode":""} OS Version: Microsoft Windows NT 10.0.22631.0 (x64 en-US) CLR Version: 4.8 or later [Release Number = 533320] Peak Virtual Memory: 70.9 GB Private Memory: 597 MB Peak Working Set: 693 MB IE Version: 11.1.22621.0 User ID: eb35982f-8947-4f67-91b1-5ffc6525e1fb Workbook Package Info: 1* - en-US, Query Groups: 3, fastCombine: Disabled, runBackgroundAnalysis: False. Telemetry Enabled: True Model Default Mode: Import Model Version: PowerBI_V3 Enabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_b2bExternalDatasetSharing PBI_enhancedTooltips PBI_sparklines PBI_scorecardVisual PBI_NlToDax PBI_fieldParametersSuperSwitch PBI_angularRls PBI_onObject PBI_setLabelOnExportPdf PBI_dynamicFormatString PBI_oneDriveSave PBI_oneDriveShare PBI_useModernPublishDialogs PBI_gitIntegration PBI_tmdlInDataset PBI_newCard PBI_buttonSlicerAuthoring PBI_EimLessElevatedUser PBI_mobileAutoReportLayout PBI_daxInlineCopilot PBI_aiNarrativesVisual PBI_qnaImproveLsdlCopilot PBI_generateMeasureDescriptionsButton PBI_visualCalculationsAuthoring PBI_desktopReportAuthoringCopilot Disabled Preview Features: PBI_publishDialogsSupportSubfolders PBI_enhancedReportFormat Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud Recent Actions: VisualContainerUpdateDimensions, SaveFormattingValues, SaveFormattingValues, SaveFormattingValues, SaveFormattingValues, VisualConversion, RemoveFieldFromRole, AddFieldInRole, SaveFormattingValues, SaveFormattingValues, VisualContainerUpdateDimensions, VisualContainerPersistProperties, VisualContainerPersistProperties, Paste, VisualContainerUpdateDimensions DPI Scale: 150% Supported Services: Power BI479Views0likes1Comment