Forum Discussion

Bali2022's avatar
Bali2022
Frequent Visitor
2 years ago

Power BI Dynamic Questionaire - Help with DAX

Hi there!  I want to create a "decision support tool"  in Power BI that helps users decide on which labor type (e.g. Contingent Worker, Full-Time Employee, or Statement of Work) they should employ for a project.  I've setup a table in PBI that I'm calling "QuestionFlow" (see below).  Based on the users Yes/No answers to the various questions I either want another question to display or a specific text value to display for the user.  I've created another table called "UserResponse" which simply has values of "Yes" and "No" and then I created a slicer from that.  At this point I'm stuck on the DAX to write (I'm a rookie) in order to dynamically display the series of questions/text based on the user's responses.  Any guidance would be greatly appreciated!

Need Help

3 Replies

  • Bali2022's avatar
    Bali2022
    Frequent Visitor
    2 years ago

    This is what my "QuestionFlow" Table looks like...

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Bali2022 

     

    Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

     

     

     

    Best Regards,

    Jayleny

    • Bali2022's avatar
      Bali2022
      Frequent Visitor
      2 years ago

      Hi Anonymous  -  Here is a link to my sample PBI file:

      Sample PBI file 

      Within the file if you look at the "QuestionFlow" table the records in this table represent the question flow I want the user to run through starting with the question under "QuestionID" Q1.  After they answer this question with either a "Yes" or "No" response this will determine the next QuestionID and QuestionText they are presented with.  In the "Report View" of the attached file I've started to place "Card" and "Slicer" visuals on my canvas to display the various questions and user responses but I can't seem to get the associated DAX measure code correct in order to properly run through the "QuestionFlow".  Hopefully what I'm looking to accomplish is clear.  If not please let me know and I'll try to clarify.  Thanks very much for your help!