Forum Discussion

FabioN's avatar
FabioN
Frequent Visitor
6 years ago
Solved

Line chart: cannot insert field into Y2

Hello all,

I have the following data structure

 

DateProductIDStockMinimumStock
01/01/2020Product112530
02/01/2020Product17530
03/01/2020Product11530
04/01/2020Product16530
01/01/2020Product2100150
02/01/2020Product2200150
03/01/2020Product2160150
04/01/2020Product2160150


Stock is the number of items of that product I had in my storage on that given day 

MinimumStock is the minimum number of that item to trigger the order

Date in my example table is dd/mm/yyyy, just to clarify.

 

The real table I'm using has about 300k rows, and more than 1k products.

 

I would like to get something like this:

 

 

 

 

 

 

 

 

 

 

 

 

In this way, when i filter for a single product, I get his storage movements and his minimum stock, and I can compare them.

 

In PowerBI, I got a line chart with

Axis: Data

Legend: ProductID

Value: Stock

 

If I try to add MinimumStock to Y2, nothing happens. Like I drag the column over the Y2 box, it gets dashed, I drop it and nothing, it does not get added to the Y2 box or the chart.

If I just check the column name, it goes into the tooltips, but that's not what I want.

Any suggestion? Even if I manually add this simple example data to my PowerBI model, it behaves in the same way.

 

Thank you very much!

Fabio