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.
Hello Team,
I need to show the title of the report as Sales Report - September 2018. In my report there are two filters called month and year. Based on the filters title month and year value need to be changed. If no filter is selected I need to show latest month and year available in the given data. Some one help me in this regard.
Hi Shiva,
Create a measure "ReportTitle"
copy & paste below DAX and change the table/field name as per your setup.
ReportTitle =
VAR ReportName = "Sales Report"
VAR SelectedMonth = IF( ISFILTERED( 'Date'[MonthShort]), SELECTEDVALUE('Date'[MonthShort]),"")
VAR SelectedYear = IF( ISFILTERED( 'Date'[Year]), SELECTEDVALUE('Date'[Year]),"")
RETURN
IF(
SelectedMonth="" && SelectedYear="",
"Latest Report",
ReportName & "-" & SelectedMonth & " " & Selectedyear
)
'Date' is a calendar table having 'Monthshort' and Year as fields
MonthShort = FORMAT('Date'[Date],"MMM")
Year = Year = FORMAT('Date'[Date],"YYYY")
I tested this okay , hope it works for you too.
Cheers,
Bob
@BobBI thanks for the solution. But we need default approach as well for the requirement. If no value is selected in month and year filters we need to show most recent month and year. This default requirement also to be met.
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |