Forum Discussion

AlexAlberga727's avatar
AlexAlberga727
Resolver II
6 years ago
Solved

This Should be Simple - Line Graph

I'm not sure why this is not working, hopinh someone here will be able to assist.   I am attempting to create a graph that will show 'Stock Levels' for certain products by date within a Line Graph....
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Try this, select "stock value" on your "fields" ( all the way to the right). and go to modeling tab, then select "don't summarize". Hope that will solve your issue. If it does, please give me a kudos!!

AlexAlberga727's avatar
AlexAlberga727
Resolver II
6 years ago

Anonymous Thanks for replying. 

 

This was initially what I thought the issue was. However, the option to not summerize wasn't available. The only options were to SUM, MIN/MAX, AVG - but no option to not summerize. I then created a measure that was simply =SUM(Stock Value). Thinking this would SUM the date's stock value for the selected SKU, and not ask for a type of summerization.

 

    • AlexAlberga727's avatar
      AlexAlberga727
      Resolver II
      6 years ago

      v-lid-msft  Thanks for helping. This solution worked. Implemented a calculated column utilizing the =RELATED DAX. Same values are being populated, but now the visualization works as expected.

       

      Thanks again!