Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
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 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!!!

  • 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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super 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
      Administrator
      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