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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Quiny_Harl
Resolver I
Resolver I

Create a slicer based on separate parts of a string

This is my table:

 

Quiny_Harl_0-1598963452204.png

Each ID has several markets separated by coma. I need a slicer where the entries will be like 1. IT 2. UK 3. GR, instead of the whole string.

1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

Hi @Quiny_Harl ,

 

You can do following:

  1. Go to Query Editor
  2. Select your "Main Markets" column
  3. Click on Transform --> Split Column --> By Delimiter  as shown below:Pragati11_1-1598964257392.png

You will end up with multiple columns, having all the values from "Main Markets" column; that are now split by ",". Use these columns as filter on your report.

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@Quiny_Harl , try split of the column into rows or column if that can help

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

vanessafvg
Super User
Super User

Are you wanting to split them into separte columns, or in the same column but in separate lines? in power query (transform data option) you can split by delimimiter using your comma (,) to create columns.




If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Greg_Deckler
Super User
Super User

@Quiny_Harl - You will have to split that column out and then unpivot the resulting columns in order to get something that you could use in a slicer.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Pragati11
Super User
Super User

Hi @Quiny_Harl ,

 

You can do following:

  1. Go to Query Editor
  2. Select your "Main Markets" column
  3. Click on Transform --> Split Column --> By Delimiter  as shown below:Pragati11_1-1598964257392.png

You will end up with multiple columns, having all the values from "Main Markets" column; that are now split by ",". Use these columns as filter on your report.

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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