Forum Discussion

PBInewbie21's avatar
PBInewbie21
Icon for Helper II rankHelper II
5 years ago
Solved

Date slicer values in Table title

Is it possible to pull DateRange from Date slider slicer (From and To) and show on Table title or in normal Text box? And the values should change Date in Date Slicer  

Thanks!

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  PBInewbie21 ,

     

    Create a measure as below:

     

    Measure = 
var _mindate=MINX(ALLSELECTED('Date'),'Date'[Date])
var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[Date])
Return
"Orders from"&_mindate&" to "&_maxdate

     

    Then click the table visual>format>title:on>format:

    Finally you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

6 Replies

    • PBInewbie21's avatar
      PBInewbie21
      Icon for Helper II rankHelper II
      5 years ago

      Thanks for quick reply amitchandak . 

      I used MAXX function in the DAX you provided 

      New Measure  =

      "Order from " & Minx(allselected('Date'),'Date'[Date]) & " " & Maxx(allselected('Date'),'Date'[Date])

      Problem is it is showing thr min and max date from Date table but not the exact date which is entered/ picked in Date slicer.

      Is it possible to grab values from Date range boxes?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi PBInewbie21 - Yes this is possible

    Try creating a measure Something like:

     

    Start Date =
IF (
ISFILTERED ( [TableName]) && HASONEVALUE ([TableName] ),
FIRSTNONBLANK(TableName[Start Date],0))
    End Date =
IF (
ISFILTERED ( [TableName]) && HASONEVALUE ([TableName] ),
FIRSTNONBLANK(TableName[End Date],0))

     

    and dispay these 2 fields in a speperate cards

     

    Or

     

    Make another measure something like:

    Orders From [Start Date measurse] to [End Date measure]

     

    Hope this helps.

     

    Cheers,

    -Namish B

    • PBInewbie21's avatar
      PBInewbie21
      Icon for Helper II rankHelper II
      5 years ago

       

      Thanks Anonymous for your reply.

      I do not have Start date and End date columns in my Order table. It only has Name, Order Date and Qty columns.

      Also, I want to grab values from Date range boxes, Is it possible? Attaching the image for clearity.

      So, I want to see Table Title 'Orders from 1/1/2020 to 6/16/2020' 

      with amitchandak 's syntax it shows Orders from 1/1/2020 to 5/1/2020 as there are no more records after 5/1/2020 in Orders table. Any idea?

       

       

      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi  PBInewbie21 ,

         

        Create a measure as below:

         

        Measure = 
var _mindate=MINX(ALLSELECTED('Date'),'Date'[Date])
var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[Date])
Return
"Orders from"&_mindate&" to "&_maxdate

         

        Then click the table visual>format>title:on>format:

        Finally you will see:

        For the related .pbix file,pls see attached.

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my post as a solution!