Split columns

[Anonymous]

Hi, 

I am new to Power BI and am trying to create a report from a large Excel file imported.

Many of my columns have data delimited by commas.

e.g.

Product ID - 1234

Locations - US,China,Australia

Colors - Blue, Green, Black, White

I need some graphs in my report to be be based on individual locations and colors. For e.g. color wise sales reports and location wise sales reports.

I could split the columns into rows but then I fear I may have to struggle with other simple graphs where unique product values are required. 

Any suggestions please. Thanks in advance. 

[Ashish_Mathur · Accepted solution]

Hi,

You should defenitely split data into rows - that is the correct action to perform.

[amitchandak]

Check if this can help 

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting