Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago
Solved

Dynamic title with date filter

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...
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

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:
acf24_0-1624883415182.png

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

Thanks a lot!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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