Data Modeling for Power BI using Raw Data

Hi,

In the Query Editor window of PBI desktop, right click on the second column of the Workshops_Table and go to Split > Split b delimiters > Specify , as a seperator.  Under Advanced, select rows.

Hope this helps.

Hi dasingh9，

You could prepare your data model in Query Editor. Assuminng that you have two tables (WORKSHOPS_TABLE, APPOINTMENTS_TABLE).

1. Go to Query Editor

2. select one table then select the column Faculty to Split column by Delimiter

3. select columns Faculty.1 and Faculty.2 with Ctrl and click Unpivoted Columns

4. Rename the Value to Faculty

5. Remove the column Attribute

6. do the same option for another table

7. Close and Apply

Then you could create the chart below.

For reference, you could have a look at my test pbix file attached below.

Best Regards，

Cherry