Forum Discussion
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
- grades 3,2,1,
- status which has 3 options (Active, Trial Withdrawn and Suspended) only Trials with Active status will be used in the visual
- 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:
| Drug | Trial | Completion Date | Grade | Status | Unique Trial |
| A | 12 | unknown | 3 | Active | Yes |
| A | 13 | Jun 2020 | 3 | Active | Yes |
| A | 14 | Aug 2020 | 2 | Active | No |
| B | 15 | May 2020 | 3 | Active | No |
| B | 16 | Sept 2021 | 1 | Active | Yes |
| C | 17 | Sept 2020 | 2 | Active | No |
| C | 18 | Oct 2020 | 3 | Active | Yes |
| C | 12 | Nov 2020 | 2 | Active | Yes |
| D | 14 | Jan 2021 | 1 | Active | Yes |
| D | 22 | Feb 2020 | 2 | Active | No |
| D | 223 | Mar 2022 | 3 | Active | Yes |
How can this be achieve?
- Anonymous6 years ago
Anonymous
Did you try the Gantt chart in power bi:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380765It 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
- amitchandak
Super User
Anonymous , I did not get it completely. But using matrix and icon in conditional formatting you should be able to get something like this
refer this
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
There is an option to only display icon.
- AnonymousNot applicable
Anonymous
Did you try the Gantt chart in power bi:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380765It 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.