Dax Formula for Graph Multiple Series with Variables from User Inputs

[brianarwiley]

I have a report user that wants me to create a graph where the data points are based on inputs he can enter (using slicers pick a product, a date range, a system, etc. There are at least six different entries in total) and then put a second set on the same chart. The example in excel is he creates series based on different inputted information and then creates a graph that compares the two. Is there a way to do this with dax so it's based on user inputs through slicers but they don't have to create the graph? Here is his example that he creates in excel for his reporting. 

The batches are not defined in our system, the engineers and production just know based on date range which items belong in which batch, so they aren't something I can control or easily define. The user (engineers/production team) need to be able to define each series for the graph in the power bi report. 

[v-lgarikapat · Accepted solution]

Hi @brianarwiley ,

Thank you for reaching out to the Microsoft Community Forum.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Best Regards,
Lakshmi Narayana

[v-lgarikapat]

Hi @brianarwiley ,

If your issue has been resolved, please consider marking the most helpful reply as the accepted solution. This helps other community members who may encounter the same issue to find answers more efficiently.

If you're still facing challenges, feel free to let us know—we’ll be glad to assist you further.

Looking forward to your response.

Best regards,
LakshmiNarayana.

[v-lgarikapat]

Hi @brianarwiley ,

If your question has been answered, kindly mark the appropriate response as the Accepted Solution. This small step goes a long way in helping others with similar issues.

We appreciate your collaboration and support!

Best regards,
LakshmiNarayana

[v-lgarikapat]

Hi @brianarwiley ,

As we haven't heard back from you, we are closing this thread. If you are still experiencing the same issue, we kindly request you to create a new thread we’ll be happy to assist you further.

Thank you for your patience and support.

If our response was helpful, please mark it as Accepted as Solution.
 Feel free to reach out if you need any further assistance.

Best Regards,

Lakshmi Narayana