Hello Everyone,
beginner to PBI here.
I'm trying to create a line chart that shows multiple lines from different sources and calculations.
Within Excel I was able to realize this but with PBI it seems to be impossible, which should not be the case I guess.
The table for the main needed information looks like this:
| Project | Country | Status | Screening Date | Randomization Date | Count Screenings | Count Randomizations |
| A | Germany | Randomized | 12.12.2019 | 18.12.2019 | 1 | 1 |
| A | Poland | Screened | 13.12.2019 | | 1 | 0 |
| B | Germany | Randomized | 13.12.2019 | 18.12.2019 | 1 | 1 |
| B | Germany | Screened | 17.12.2019 | | 1 | 0 |
A graph is needed for Screening and Randomization over time where all randomized status means that they also count for screening status. Which means in the above case Project A and B have each 2 Screened and 1 Randomized
I managed to sum up per study and show in a graph per status but not in one graph for both status (Using the extra colum with count).
For me it seems to be the date which cause these problems.
I tried to connect to a Calendar table but this didn't work and the graph did not show sum of each dateat all.
I hope that someone has an idea how to solve this problem.
In an addtion step more lines need to be added such as planned Screenings over time form another table.
Glad to get feedback.
Best CAllme
