Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 desktop that just shows current year ?
Solved! Go to Solution.
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.
Hi @Anonymous,
Showing current year in header for report can be done with help if DAX measure and Card visual.
DAX measure:
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.
I am using card visual and a measure in the table, so good thing is, even though there is no data in the report I can see the header
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.
You mean create a new dax measure column which is static ?
Hi @Anonymous,
Showing current year in header for report can be done with help if DAX measure and Card visual.
DAX measure:
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.
Hi @Anonymous
I'm not sure if you mean you want to show the current year i.e. 2020, or the currently selected year?
And do you want the heading to read Sales for the year 2020 ?
Please clarify. If you just want the current year (2020) this measure will do
Current Year = CONCATENATE("Sales for the Year ", FORMAT(TODAY(),"yyyy"))
Phil
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.
Proud to be a Super User!
so here is the requirement, It doesnt have to do anything with the data,
In my power bi heading for the report, I just want to show
sales report - November 2020
The month and year should always show current month and year....thats all, nothing fancy, I can write oracle function to display this information in the oracle view i am using as source, but if there is no data for the month it would be empty....can I use dax somehow in the power bi header to show this info ? (maybe in a card ?) , dont want to invovle data table etc
so here is the requirement, It doesnt have to do anything with the data,
In my power bi heading for the report, I just want to show below in the header of report whether there is data or not
sales report - November 2020
The month and year should always show current month and year....thats all, nothing fancy, I can write oracle function to display this information in the oracle view i am using as source, but if there is no data for the month it would be empty....can I use dax somehow in the power bi header to show this info ? (maybe in a card ?) , dont want to invovle data table etc
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |