Forum Discussion
Line chart marks from different tables
Have you tried adding the data to a table visual? its easier to make sure that you are getting the correct results in a table visual before trying to create a line chart or other visual against it
In the case of what your trying to do, Overwrite the label with the Medication where that medication has been taken I dont think you can do that with a Line chart.
You might try to customise the series if you add in Medication into Series
And create a different colour for each medication. I dont have enough data to see if working but its worth a try. Thi still wouldnt show the medication on the line chart though. I would definitely add it as an idea but to support it you need to be able to produce a table with the date thickness(Metric) and Medication in power BI first
I made that customization in the line chart yesterday as you mentioned, and work fine without the name of medication. I joined all the data in a unique table like this
PACIENTE_ID MEMBRANE_THICKNESS MEDICATION DATE
| 1 | 400 | OCT | 15/06/2019 |
| 1 | 426,67 | LUC | 18/06/2019 |
| 1 | 488,89 | LUC | 25/06/2019 |
| 1 | 542,22 | LUC | 01/07/2019 |
| 1 | 604,44 | LUC | 08/07/2019 |
| 1 | 666,67 | LUC | 15/07/2019 |
| 1 | 800 | OCT | 30/07/2019 |
| 1 | 800 | OCT | 01/01/2020 |
| 1 | 738,6 | OZURDEX | 08/01/2020 |
| 1 | 615,78 | OZURDEX | 22/01/2020 |
| 1 | 484,21 | OZURDEX | 06/02/2020 |
| 1 | 361,4 | OZURDEX | 20/02/2020 |
| 1 | 300 | OCT | 27/02/2020 |
OCT is the exam, if you see all the membrane_thickness between OCTs are calculated to be exactly over the line chart (In the transactional system the membrane_thickness is 0 for OZURDEX, LUC, EYLIA and other medication), but this calculation is not simple i need to do line by line maybe it is not the smarter and simple way. But the result was:
Yesterday, i posted this topic looking for a smater and simple way to do it.
Might be worth having a look at some of the custom visuals.
The pulse chart is pretty nice but its very much a case of actually clicking on the visual, or running the visual to look at the medications
Its a pity the medication markers dont stay up until you click on them but its quite nice. Medication is in Event Description