line charts
2 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.3KViews0likes7Comments