Display circle in a Matrice

[Testy]

Hello everyone,

I'm currently working on a tableau migration, and in tableau we have this kind of visual

I was able to create th circle via SVG, but I would like to be able to display the circle in this kind of displaying
So the issue is that I can have until 10 circles, I'm seeing a way to solve that, can you tell me if my idea is fine or if you see a better way to achieve it?
So, the point has in common a bill ID, each point represent a comment on the bill (from the customer or the accounting team)

So my idea would be to create a column with the following id

Bill ID	Comments	Date of comments	Calculated Column
1	A	01/01/2022	1
1	B	05/01/2022	2
1	C	10/10/2022	3
2	E	02/01/2022	1
2	F	07/07/2022	2
2	G	09/09/2022	3
3	H	01/30/2023	1
3	I	08/12/2023	2
3	j	12/12/2023	3
3	K	01/11/2024	4
3	L	02/02/2024	5

Then I could display my calculaed column in my visual and in the value add my svg measure

Any idea of how could I achieve that ? And do you see an easier way to do that?

Many thanks for your help 🙂

[Anonymous · Accepted solution]

Hi @Testy ,

It's possible. You can display circles based on the below blog.

Tips on displaying icons based on field values in ... - Microsoft Fabric Community

For example, unicode can be regarded as a text character, so function ‘rept’ is applicable to it.

Best Regards,

Stephen Tao

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