How to create a common identifier between multiple columns

Hi harshadrokade ,

You can use the "Unpivot Columns" feature in Power BI to bring all the months into a single column. After that, you can use the "Group By" feature to group the data by the month column and the parameter column. This will give you a single row for each month and parameter combination. You can then use this data to create combo charts with multiple parameter combinations.

Here are the steps to unpivot columns:

1. Select the columns you want to unpivot.
2. Right-click on the selected columns and select "Unpivot Columns".
3. This will create a new column called "Attribute" and a new column called "Value". The "Attribute" column will contain the original column names, and the "Value" column will contain the values from those columns.
4. Rename the "Attribute" column to "Month" or "Parameter" as appropriate.

Here are the steps to group by:

1. Select the "Month" and "Parameter" columns.
2. Go to the "Transform" tab and select "Group By".
3. In the "New column name" field, enter a name for the new column that will contain the grouped values.
4. In the "Operation" field, select the operation you want to perform on the grouped values (e.g. Sum, Average, Count).
5. Click "OK" to create the new column.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.