Forum Discussion

liselotte's avatar
liselotte
Advocate I
1 year ago
Solved

Line 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.

  • Not at the moment. Power BI currently does not support dynamic binning. You need to bring your own buckets.  Or use Tableau.

1 Reply

  • Not at the moment. Power BI currently does not support dynamic binning. You need to bring your own buckets.  Or use Tableau.