Forum Discussion

Frequent Visitor

2 years ago

Solved

Power BI column dynamically need to added

This is input excel sample data for 5 months, for the data I am using table visual. In this visual I have placed al the column in the visual and I was able to get table visual however one month colum...

rajendraongole1
2 years ago
Hi R_K_Damera - you have to create two calculated columns based on Month No and Month Name
first calculated column:

Month = FORMAT(Pivot[Date],"mmm")

Monthno = MONTH(Pivot[Date])

Once added the new columns, go to the report view and use matrix visualization, add Month Name on Columns and Data is on Rows and Values on Values tab.

Above is the output you can get it. Please check

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

rajendraongole1

Super User

2 years ago

Hi R_K_Damera - you can do this in power query editor, select the columns which you no need to do unpivot, please follow the steps as below:

Once you unpivoted other columns , you can see attributes and values and then convert to date datatype and rename it as Date.

Once you loaded the data into power bi desktop, you can easily develop and get the dates dynamically into visualization. no need to add manual entry as like below visualization.