 Hey guys, welcome to SSURitech, so we will decide and today we are going to see a scenario inside the Power BI. So basically how could we change the column names dynamically in the Power BI. So here for example we can see in the top side we are having this slicer and in the bottom table we are having the data. So if we select the city on the slicer then columns will be changed according to selection of that. So here we can see all the city's data is in column, now let me switch to country. So once we select the country then we can see all the information which is related to the country names are in the column. Now we change the customer ID then we can see all the customer IDs after that we can see the product names, so these are the product names available on the columns. So it is changing according to our selection, so dynamically it would be changed. So how could we create this for that, go to on the next file. So here I have already loaded the data, so if you want this source data then you can drop the email on the comment box, so I will provide the source file. Now go to on the transform data, first thing what we want to do, we want to create one more column that will have only those columns which we want to see in the slicer. All we want to see the change values dynamically for those columns. So here first of all I would suggest to create one more column that will be the index column, so go to on the add column and here you can see the index column. So if you want to create the index from 0 or 1 you can do that, so I am very happy to use from 1 and this is index. Now you can create the duplicate, so right click on the query and create a duplicate for that. And here you can rename this, so I am going to rename as master and here as I told you we want to keep only those columns which is related to the dynamically changing columns. So first is customer ID, so we can select that one, now go to on the right side and here the second column that will be the product name, so we can select that one, now go to on the right side and here we can see the city, so we can select that city and the last column that will be the country name, so these four columns will be changing by selecting the values, the last column that is index we should keep that as well. Now go to on the home and here you can see the remove other columns, so other columns will be removed and it keep only these five columns. The second thing that I would suggest to do the unpivot by using these four columns, so we can select these four and go to on the transform and here you can see the option for unpivot, so we can click on that. Here you can see the attribute, so these are the columns by which we want to do the change, so we can rename this and these are the values, so I am very happy as of now and we can load this into PowerGlade desktop, so close and apply and we need to wait few seconds it will be loaded in the PowerGlade desktop, now it is loaded successfully, now next thing go to on the relationship, so here as you can see it is already created the relationship, if it is not created on dual then you can delete and here it might be like this, so you can go on the index and try to drag this index and drop in the master, now it is created, now go to on the report view, so inside the report view first thing I would suggest to use the matrix, so this is the matrix and you can increase the size as you want and here go to on the master file and here you can see these are the columns and these are the index and the value, so this value should go inside the columns and next thing go to on the sales detail and here I would suggest to use the sales order id on the row, so you can scroll down little bit and here these are the sales order id, so you can drag this and drop in the rows, in the values we want to see the sum of order quantity, so this is the order quantity we can drag and drop in the value and here we can check this is the sum, so that is good, so here we can see we are having all the values like the country, the customer id and everything that we have on these 4 columns, so next thing that will be slicer, so we can select the slicer and you can decrease the size and here go to on the master table and drag this column and drop on the field, so we can see all these, now go to on the format and here you can see the selection control and select single, so here it is selected city now, now let me switch to country, so we can see all these countries, now switch to customer id, so it will show the customer id on the columns, now switch to product name, so these are the product names and you can do the formatting as you want, so this is very simple as I have explained step by step, if you have still any doubt you can drop the comment and I will try to response on your comment, thank you so much for watching this video and please subscribe our channel to get many more videos, please share this video to your friends, thank you so much guys.