How to avoid repeating column value and show only one single value of it?

[IloveTigray]

I am new for Power bi.

I have a filer mechanism: service

service

• All Service
• COMS
• ORM
• IT
• Media

the data on the table will be displayed based on the  Service filter value selected

example if "IT" is selected the power bi displays

Service	Section	Title
IT	Computer	computer training..
IT	Software	Software application
IT	Database	sql server database...

Service column is repeating , so I want to  avoid it, instead , i want to show it above the table:

Service:IT

Section	Title
Computer	computer training..
Software	Software application
Database	sql server database...

How can I display that?

my second question: I want to show checkmark box in the service list, how can i do that?

[v-yueyunzh-msft]

Hi, @IloveTigray 

Thanks for your sample data first!

According to your description, you want to avoid repeating column value and show only one single value of it.

Here are the steps you can refer to :
(1)This is my test data:

(2)We can close the "text wrap" for the table visual:

Then we can drag our mouse to display the column we do not want to show:

(3)If we want to show what you have selected you can create a measure and put it on the card visual:

Measure = 
 var _selected =  VALUES('Table'[Service])
 return
 "Service" & ":"&CONCATENATEX(_selected,[Service],",")

The result is as follows:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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