Power BI Pivot Report - Rows value is in Column data
Power BI provides a wonderful platform to generate complex reports. Today, I'm going to walk through one such example. I have master and child tables and what I want to draw is - one of the column's data in master table will have row entry, and associated child tables row data will be display in column. In excel, this is called pivot table. So, bring a pivot table of UI in Power BI. Below the example data. I have one master table entry where different object names are exist in individual row. Also, child table contains sub-objects based on the master table object name. Now, what I want is, all objects will be displayed (here Car, Rail, Aeroplane) will be displayed in row wise, and their's associated sub-objects will be displayed in columns wise and contains field value of other sub-object. How we'll achieve this? First thing is load the data in Power BI desktop and then create the master- child relationship. Now, if you go the the report pan, you will fin