Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How can I visualize the following mockup?

I realize that I might not be able to create the mock-up in the image below using one visual.  Perhaps I need to visuals?  However, that would create a problem with trying to keep the x-axis in sync.  Essentially I need one horizontal line at the bottom that shows the drug the patient was taking.  At the top, I need a line chart that shows lab values over time.

 

Thoughts?

 
 

8 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion

    Anonymous 

     

    Is this what you are looking for more or less?

     

     

     

    Here is the PBIX file if it might help:

     

    Tracing Results by Drug Type 

     

    As an alternative, you can show each drug along the same line:

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      This is great!  Thank you so much for building this.  I looked at how you did this.  Would it be possible if the 5 drugs are dynamic?  Meaning there could be 100 drugs total, but for a particular patient, it would only be 3 or 4.  Is there a possible implementation of this?

      • PaulDBrown's avatar
        PaulDBrown
        Icon for Community Champion rankCommunity Champion

        Anonymous 

        My bet is that it can be dynamic, for sure. Of course the way to implement it is dependent on the data structure and how you would select each patient (slicer I would imagine).

        If you can provide a mock-up of the data I can give it a shot. 

  • Anonymous you can somewhat achieve this using Line and Clustered Column chart available in visual gallery.

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion

    Anonymous 

     

    I would imagine you could achieve this using a line chart. Do you have any sample data?

    • Anonymous's avatar
      Anonymous
      Not applicable

      I will make the sample data fit if there is an appropriate solution.  So, the sample data isn't hard requirement.  I can transform it anyway necessary if I can get the visual to meet the needs.

  • adam456's avatar
    adam456
    Icon for Advocate III rankAdvocate III

    It would be great if you could create the mock dashboard wireframe before moving to the development process. You can use Mokkup.ai, which helps you create dashboard mockups that are easily replicable in Power BI.