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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
OCMarkW
Frequent Visitor

Data Model Question for dealing with Multi-Value data columns

Data Model Question for dealing with many Multi-Value data columns.       Each data column has multiple values with ";" seperators.   

 

Should I unroll the different columns values into their own tables with a relationship key back to the one original Dim record?   In other words create a star schema.

 

Or leave them and use Measures with SEARCH / SUBSTITUTE functions to select the Dim records?     

 

Which is easier to visualize?

TIA

3 REPLIES 3
ryan_mayu
Super User
Super User

@OCMarkW 

maybe you can try to split to rows in pq

1.PNG2.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Thanks.    I know how to split and manipulate the data into various tables.      I have no problems with Power Query / M and DAX measures.    

 

My question is still from a design standpoint, should I create the different tables and link them back to the original row,

 

-or-

 

just leave the semicolon values alone and use a SEARCH measure to to get the row?

i think you duplicate the column and the new column after splitting can still link back to the original column





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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