Power BI create a viz where events are represented by boxes over time

[KBD]

Hello:

I have been tasked moving a dashboard from another desktop Viz software to Power BI

I have one Viz/Chart and do not know where to start

Looks like this:

We have persons on the Y axis and dates of "events" on the X.

The Box respesent "events"   could be sales or  teaching  a class. 

the relationship is person (Y axis)  did something or is scheduled to do something.

Requirements included hovering over box to give count of sale and sum of sales.

Which Power BI viz would handle this?

Many thanks for your kind assistance.

KBD

[Ritaf1983 · Accepted solution]

Hi @KBD 
Check the Gantt charts like the manual from the matrix :

https://www.youtube.com/watch?v=8pbFvBMT9L8

https://www.youtube.com/watch?v=QugkBqc-jIs

Or from a marketplace:

https://www.youtube.com/watch?v=U5UMz8xJ4t4

Or with deneb :

https://www.youtube.com/watch?v=GZ5nVVsYGUw

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous · Accepted solution]

Hi, @KBD 

Maybe you can use gantt visual. Here is a sample table:

In the Visualizations panel, click the three dots (More Options) and select Get more visuals. Search for Gantt Chart and add it to your report.

Drag the Gantt Charter visualization onto the report canvas and assign the fields. Here is my preview:

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KBD · Accepted solution]

In the end I went with a Matrix.   The left columns are the static data,  the Person ( the student or drive) 

and then the grid is the count of classes or trips.  

I think better than the original cause it give you the count of events in the viz.

Thanks for the suggestions.  

[Anonymous · Accepted solution]

Hi, @KBD 

Maybe you can use gantt visual. Here is a sample table:

In the Visualizations panel, click the three dots (More Options) and select Get more visuals. Search for Gantt Chart and add it to your report.

Drag the Gantt Charter visualization onto the report canvas and assign the fields. Here is my preview:

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983 · Accepted solution]

Hi @KBD 
Check the Gantt charts like the manual from the matrix :

https://www.youtube.com/watch?v=8pbFvBMT9L8

https://www.youtube.com/watch?v=QugkBqc-jIs

Or from a marketplace:

https://www.youtube.com/watch?v=U5UMz8xJ4t4

Or with deneb :

https://www.youtube.com/watch?v=GZ5nVVsYGUw

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[lbendlin]

This is usually done with custom visuals like Deneb. 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...