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.
