Dynamic title with date filter

[Syndicate_Admin]

good

I want to create a dynamic title that is "Report for XX/YY"

In which XX is the month that I choose in a segmentation of data that I have, it is a segmentation in which I choose the month of a specific year, but the field of the date that I add to the segmentation of data is of the type XX / YY / ZZZZ, I only want to keep the month and the year, since my ranges will be monthly.

With selectedvalue (as I have done with other filters that I also have) nothing appears to me. How should it be?

Thanks a lot!!!

[amitchandak]

@Syndicate_Admin , Assume you are selecting a month from slicer which based on table having date

Try a new meausre

=

var _max = maxx(allselected(Date), Date[Date])

return

format(_max,"MM/YY")

[Syndicate_Admin]

Excuse me, I haven't explained myself quite well.

The problem is that I have two different graphs, to which I apply a different segmentation of data to each one (in one of them I want to give me data of the month that I choose in the segmentation and in the other the count of data of the last 6 months). These slicers are made with the same field from the same table: Batch End Date (which is of type XX/YY/ZZZZ).

I just want you to choose me the segmentation of the whole month, and I want it within a new measure that I have created which is:

Title = "LINE " & SELECTEDVALUE(EPLinea[Line]) & " - CRITICAL REJECTIONS IN PRIMARY CONDITIONING" & "

" & "MONITORING TO EVALUATE " this is where I want to put the name of the month, for example MARCH/2021

and the slicer I want to get it out of is:

I don't tell if I've explained myself better now....

Thanks a lot!!

[v-shex-msft · Accepted solution]

Hi @Syndicate_Admin,

Did you mean to show the selected month range in your measure? If that is the case, you can tyro to use the following formula:

Title =
VAR _list =
    ALLSELECTED ( Table[Date] )
VAR _min =
    MINX ( _list, [Date] )
VAR _max =
    MAXX ( _list, [Date] )
RETURN
    "LINE " & SELECTEDVALUE ( EPLinea[Line] ) & " - CRITICAL REJECTIONS IN PRIMARY CONDITIONING "
        & FORMAT ( _min, "MMM/YYYY" ) & " ~ "
        & FORMAT ( _max, "MMM/YYYY" )

Regards,

Xiaoxin Sheng