Forum Discussion

Young_G_Han's avatar
Young_G_Han
Icon for Helper III rankHelper III
2 years ago
Solved

Dynamic Column Name changed by the selected Year & Month

  Dear Kudos   I am converting an old Excel file report to the BI.   The old Excel file has many customized columns and cells.   One of my missions is to create measures for the following table...
  • Dangar332's avatar
    2 years ago

    hi, Young_G_Han 

    There no direct posiibility to create such things but you can make a new measure for selected year and make card visual and overlap it in measure or column name

    like below
    make new measure for selected year only

    selected year =
    SELECTEDVALUE('Data Date'[Year])
     
    make a new card visual and drag above measure here then resize it and disable catagorical label

    overlap it on column where you want to use for selected year total and avg. like below image

    here yellow color is card visual after resize it and red color is measure name


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