Group rows in table visual

[gduobaite]

Hi, 

is it possible to group the same text (1st column) in one row in table visual?

I know it is simple with matrix, but I can't use it, so need the same solution in table. 

Thanks. 

[v-eqin-msft]

Hi @gduobaite ,

1.Use Conditional Formatting:

Measure =

SWITCH ( MAX ( 'Table'[Cate] ), "Form", "Red", "Format", "Light Green" )

2. Use Group by 

Here is my pbix file.

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[gduobaite]

@v-eqin-msft , thank you for your time, but your solution does not satisfies my problem.. 

[amitchandak]

@gduobaite , I do not think you can do that in table visual. You have to use the Matrix.

[gduobaite]

@amitchandak , I was thinking about Group by or even Conditional formatting... But no ideas.

Why I can't use matrix because I don't need values in there and without values I can't use conditional formatting to my needed column.