Forum Discussion
Kohrinn
Helper I
Helper IA chart for recurring events?
Hi everyone,
I would like to create a chart like on the picture below. I have some events in my database and I want to place their duration on the chart. Is it even possible with Power BI? What tool do I use to do that? I've tried Gantt but it's not really the answer to my problem - it puts recurring events in separate rows, which I don't want. Any ideas? Thanks in advance!
Best regdards,
Joanna
Hi Kohrinn ,
Have you tried using a matrix?
In this case you should do a calendar table and add two metrics:
Colour = SWITCH(SELECTEDVALUE('Table (2)'[Event]), "A", "Green", "B", "Yellow", "C", "Blue", "D", "Red") CountValues = COUNTROWS(FILTER('Table (2)', 'Table (2)'[Start Date] <= MAX('Calendar'[Date]) && 'Table (2)'[End Date] >= MAX('Calendar'[Date])))See PBIX attach.
2 Replies
- MFelix
Super User
Hi Kohrinn ,
Have you tried using a matrix?
In this case you should do a calendar table and add two metrics:
Colour = SWITCH(SELECTEDVALUE('Table (2)'[Event]), "A", "Green", "B", "Yellow", "C", "Blue", "D", "Red") CountValues = COUNTROWS(FILTER('Table (2)', 'Table (2)'[Start Date] <= MAX('Calendar'[Date]) && 'Table (2)'[End Date] >= MAX('Calendar'[Date])))See PBIX attach.
- Kohrinn
I haven't thought about this, thanks for the tip!
