How can I visualize the following mockup?

[Nick-Singleton]

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?

[adam456]

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.

[PaulDBrown · Accepted solution]

@Nick-Singleton 

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:

[Nick-Singleton]

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]

@Nick-Singleton 

Not sure if you have finally suceeded in making the report dynamic, but just in case, here is a way of doing it:

Unfortunately you can't do conditional formating on the legend, so I have added the reference to the drug name as a separate card underneath.

Here is the PBIX file:

Dynamic Report (Drugs by Patient) 

[PaulDBrown]

@Nick-Singleton 

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. 

[PaulDBrown]

@Nick-Singleton 

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

[Nick-Singleton]

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.

[parry2k]

@Nick-Singleton you can somewhat achieve this using Line and Clustered Column chart available in visual gallery.