Forum Discussion

gduobaite's avatar
gduobaite
Helper III
5 years ago

Group rows in table visual

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. 

4 Replies

    • gduobaite's avatar
      gduobaite
      Helper III

      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. 

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      gduobaite
      Helper III

      Anonymous , thank you for your time, but your solution does not satisfies my problem..