Generating table with icons in place of numbers

[stevenmcginnis]

This is my first post so apologies if I have posted in the wrong area or made mistakes regarding best practice when posting questions. I have data which looks something like this:Data format

And I am hoping to get a chart or matrix table which has the specific number of coloured icons in place of the number. Preferably something like the picture below, which gives a great "big picture" view of the projects being completed across three different dimensions without looking unneccesarily messy. I have found timeline visuals which look good but can't seem to replace the time axis with a stage axis.

Desired Table

 Any help in getting the above visual or even potential workarounds is appreciated.

Regards,

Steven

[stevenmcginnis]

Thanks for the response @lbendlin.

Here is a table of what the data might look like:

Project	Team	Type	Stage
Project 1	Team 1	Type 1	Stage 1
Project 2	Team 1	Type 2	Stage 2
Project 3	Team 1	Type 3	Stage 3
Project 4	Team 2	Type 1	Stage 4
Project 5	Team 2	Type 2	Stage 1
Project 6	Team 2	Type 3	Stage 2
Project 7	Team 3	Type 1	Stage 3
Project 8	Team 3	Type 2	Stage 4
Project 9	Team 3	Type 3	Stage 1
Project 10	Team 4	Type 1	Stage 2
Project 11	Team 4	Type 2	Stage 3
Project 12	Team 4	Type 3	Stage 4
Project 13	Team 1	Type 3	Stage 2
Project 14	Team 2	Type 2	Stage 1
Project 15	Team 2	Type 2	Stage 1
Project 16	Team 3	Type 2	Stage 1
Project 17	Team 4	Type 2	Stage 1

And here is an updated picture of what the desired outcome would look like based on this sample data above:

A table with coloured icons in place of numbers, where each icon represents a project, and colour to represent the type. I'm also open to any alternative suggestions for conveying this executive summary of the projects in such a simple concise way.

Hope this is more helpful.

[lbendlin · Accepted solution]

Is this good enough?

see attached

[stevenmcginnis]

That's perfect, thank you very much!

[lbendlin]

Welcome to the forums.  Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. Screenshots of your source data are not useful.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523