Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Visualisation to show Completion Dates for Trials

Hi

I would be very grateful if a solution/ suggestion to the question below can be provided

I have a list of drugs which have different trials with associated completion dates.  E.g  Drug A has 100 trials which have different completion dates.  These trials are  classified or filtered according to

  1. grades 3,2,1,
  2. status which has 3 options (Active, Trial Withdrawn and Suspended) only Trials with Active status will be used in the visual 
  3. completion Date which has values, of  Not available, Unknown or Blank or actual date but only those with actual dates will be used.

Task:

The task is to display the list of drugs on the Y-axis and the different trials with completion dates on the x-axis in a visual. We would like to include a color scheme whereby all trials with a Completion date will be grey in color, Trials which have the answer Yes to the question unique trial? will be green .

 

Desired result:

 I had tried using the gant chart visual but it would not display the individual trial and completion date. However we achieved the screenshot below in Tableau using  a text table. But we would prefer to create the Power BI equivalent to the picture below.

 Data table is below:

 

DrugTrialCompletion DateGradeStatusUnique Trial
A12unknown3ActiveYes
A13Jun 20203ActiveYes
A14Aug 20202ActiveNo
B15May 20203ActiveNo
B16Sept 20211ActiveYes
C17Sept 20202ActiveNo
C18Oct 20203ActiveYes
C12Nov 20202ActiveYes
D14Jan 20211ActiveYes
D22Feb 20202ActiveNo
D223Mar 20223ActiveYes

 

How can this be achieve?

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous 
    Did you try the Gantt chart in power bi:
    https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380765

     

    It is unlikely to achieve the exact same, you can try the visual by putting Unique Trial in the legend and Drug in the Task. You are able to to the change colors in the format panel, but there is no conditional formatting feature because it is a imported visual.


    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous 
    Did you try the Gantt chart in power bi:
    https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380765

     

    It is unlikely to achieve the exact same, you can try the visual by putting Unique Trial in the legend and Drug in the Task. You are able to to the change colors in the format panel, but there is no conditional formatting feature because it is a imported visual.


    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.