March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Im looking to make a dynamic text box indicating what the months are for the current filter. For example, I have a last calendar month relative data filter. I need the text box to say:
The current month displayed is from 5/1/2021-5/31/2021
we have applied filters like below.
Solved! Go to Solution.
do you mean you want to dynamically get the value of the filters on this visual?
e.g.
if yes, I've tested and find the value can't be achieved by Allselected() function. so I think Filters on this visual won't apply filter to table, it only affect the display of the visual.
e.g.
so I suggest you to use the slicer and creat the filtermeasure or use the method mentioned by Fowmy
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.
do you mean you want to dynamically get the value of the filters on this visual?
e.g.
if yes, I've tested and find the value can't be achieved by Allselected() function. so I think Filters on this visual won't apply filter to table, it only affect the display of the visual.
e.g.
so I suggest you to use the slicer and creat the filtermeasure or use the method mentioned by Fowmy
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.
@saiprathapdp
Relative Date frilter works on the current date so you can create the following measure and use it on a card visual:
Date Period =
FORMAT( EOMONTH(TODAY(),-1)+1 , "dd/mm/yyyy" ) & "-" &
FORMAT( EOMONTH(TODAY(),0), "dd/mm/yyyy" )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |