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!

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!

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

Hi v-kelly-msft ,

Thanks for attaching all the screenshots and .pbix file too. Helps the newbie like me. Looks like all of the above replies would help if my date table had rows for every single day. 

Noticed that my Date table has some rows missing and that's why it pickes date value from Order table.