cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Nick-Singleton Frequent Visitor
Frequent Visitor

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?

 
 

psa.png

1 ACCEPTED SOLUTION

Accepted Solutions
PaulDBrown Senior Member
Senior Member

Re: How can I visualize the following mockup?

@Nick-Singleton 

 

Is this what you are looking for more or less?

 

Line Chart.JPG

 

 

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:

 

Single Line Chart.JPG

 

View solution in original post

7 REPLIES 7

Re: How can I visualize the following mockup?

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






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





PaulDBrown Senior Member
Senior Member

Re: How can I visualize the following mockup?

@Nick-Singleton 

 

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

Nick-Singleton Frequent Visitor
Frequent Visitor

Re: How can I visualize the following mockup?

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.

PaulDBrown Senior Member
Senior Member

Re: How can I visualize the following mockup?

@Nick-Singleton 

 

Is this what you are looking for more or less?

 

Line Chart.JPG

 

 

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:

 

Single Line Chart.JPG

 

View solution in original post

Nick-Singleton Frequent Visitor
Frequent Visitor

Re: How can I visualize the following mockup?

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 Senior Member
Senior Member

Re: How can I visualize the following mockup?

@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 Senior Member
Senior Member

Re: How can I visualize the following mockup?

@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:

 

Drug Chart.JPG

 

Single Line Chart.JPG

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) 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,056)