Forum Discussion

brianarwiley's avatar
brianarwiley
Frequent Visitor
1 year ago
Solved

Dax Formula for Graph Multiple Series with Variables from User Inputs

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. 

  • 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

4 Replies

  • v-lgarikapat's avatar
    v-lgarikapat
    Icon for Community Support rankCommunity Support

    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's avatar
      v-lgarikapat
      Icon for Community Support rankCommunity Support

      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's avatar
        v-lgarikapat
        Icon for Community Support rankCommunity Support

        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