Forum Discussion

R_K_Damera's avatar
R_K_Damera
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...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • rajendraongole1's avatar
    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!!

     

R_K_Damera's avatar
R_K_Damera
Frequent Visitor
2 years ago

Can you please help me on this

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
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!!