Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Hi @gduobaite ,
1.Use Conditional Formatting:
Measure =
SWITCH ( MAX ( 'Table'[Cate] ), "Form", "Red", "Format", "Light Green" )
2. Use Group by
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
@v-eqin-msft , thank you for your time, but your solution does not satisfies my problem..
@gduobaite , I do not think you can do that in table visual. You have to use the Matrix.
@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.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |