View a Column of Text in a Power Bi Matrix

[Syndicate_Admin]

Hello everyone, see if you can help me with this that I propose.

I need to visualize a column of text where the data is repeated several times but I want that when it is repeated I put for example a point, in this way the resulting matrix table is cleaner. But the problem is that the Matrix table considers as the same value each cell that I put as a period "". I need the result of the matrix table to see the first concept, and if it is repeated in the cell below to put a point and with the order I establish. Can you think of any way to fix it? I pass you a visual sketch to make it clearer:

Greetings and thanks in advance.

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

As far as I know, Power BI will summarize the table by group if there are multiple same values in your keycolumn in your visual. In your sample, there are multiple same values in [Actividad (nombre corto)], then Power BI will summarize [importe] columns by groups. So you will get result as second screenshot.

You can select "Don't summarize" [importe],however Power BI will sort your visual by group.

Here I suggest you to add [Orden] to expand your visual, and sort your visual by [Orden].

Best Regards,
Rico Zhou

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