Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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!
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
Thanks @NamishB 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?
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!
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.
@PBInewbie21 , You can use dynamic Title
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-titles
create a measure like this and use in the title
New Measure =
"Order from " & Minx(allselected('Date'),'Date'[Date]) & " " & Minx(allselected('Date'),'Date'[Date])
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |