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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.