Forum Discussion
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?
Anonymous
Is this what you are looking for more or less?
Here is the PBIX file if it might help:
As an alternative, you can show each drug along the same line:
8 Replies
- PaulDBrown
Community Champion
Anonymous
Is this what you are looking for more or less?
Here is the PBIX file if it might help:
As an alternative, you can show each drug along the same line:
- AnonymousNot 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
Community 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.
- parry2k
Super User
Anonymous you can somewhat achieve this using Line and Clustered Column chart available in visual gallery.
- PaulDBrown
Community Champion
Anonymous
I would imagine you could achieve this using a line chart. Do you have any sample data?
- AnonymousNot 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.