Forum Discussion
Power BI column dynamically need to added
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!!
The column type is of Text
Super UserHi R_K_Damera - you have to convert text data type to date data type. if any issues while converting we have to use the m functions . check it and get it convert let know if any errors are coming.
change data type
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Yes I have tried however data should be in the individual column as the data should be represent in table visual
exam : column 2 is Apr, Column 3 is May, etc.,,
As per above data is
Apr
May
Jun
Jul
Aug
Can you please help me on this
- rajendraongole1
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!!