Forum Discussion

acj5607's avatar
acj5607
New Member
2 years ago

line stacked

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. 

 

 

 

Need Help
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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's avatar
      acj5607
      New Member
      2 years ago

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