line stacked

[acj5607]

I have a table with Unique row of IDs. For each ID, there are columns that cover various attributes for the unique IDs (Status, impact, date created).

Trying to create column and stacked chart using the dataset, works well with just date, ID and status in legend.

However, when I enter this in the powerbi line and stacked visuals, it counts the total for the month and not individual values for the month.  

Ideally, I'd like to show on the graph using multiple lines the number of (high/medium/low - Imact (clolumn) for the given month, along with what is already in the column stacked chart. 

[amitchandak]

@acj5607 . Not very clear but you need measures like

Sumx(Table, if(([High]+[Medium]+[Low]),1,([High]+[Medium]+[Low]), blank())

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[acj5607]

I've reposted the problem, hopefully it is a bit clearer