Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Show current year

I am preparing a header for my power bi report in the following way   Sales for the year 2020 - question is how do I show the year dynamically ? Can I add a new column to the report in the power bi...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Try this:

    Measure =
"My header -" & FORMAT ( TODAY (), "mmmyyyy" )

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous,

 

Showing current year in header for report can be done with help if DAX measure and Card visual.

DAX measure: 

Report Header = "Sales for the year " & YEAR ( TODAY () )
 
Please note doing this, only header will get the value for current year, and data will be shown as per the slicers selected.
You can also think of using below DAX measure to dynamically change the year value in header, with change in the selected Year.
DAX Measure:
Report Header = "Sales for the year " & SELECTEDVALUE( 'Calendar'[Year] , "Multiple Years" )
 
Romil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.