Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
IloveTigray
New Member

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

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
ITComputercomputer training..
ITSoftwareSoftware application
ITDatabasesql 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
Computercomputer training..
SoftwareSoftware application
Databasesql server database...

 

IloveTigray_0-1685134011302.png

 

How can I display that?

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

 

1 REPLY 1
v-yueyunzh-msft
Community Support
Community Support

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:

vyueyunzhmsft_0-1685324904649.png

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

vyueyunzhmsft_2-1685325039046.png

 

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

vyueyunzhmsft_3-1685325052572.png

(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:

vyueyunzhmsft_4-1685325220567.png

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

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.