Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
saiprathapdp
Frequent Visitor

Dynamic filters has to be add in to the text box

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.

saiprathapdp_0-1624171563703.png

saiprathapdp_1-1624171580624.png

 

 

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

Hi @saiprathapdp 

do you mean you want to dynamically get the value of the filters on this visual?

e.g.

vxiaotang_0-1624355848911.png

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.

vxiaotang_1-1624356567952.png

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.

View solution in original post

2 REPLIES 2
v-xiaotang
Community Support
Community Support

Hi @saiprathapdp 

do you mean you want to dynamically get the value of the filters on this visual?

e.g.

vxiaotang_0-1624355848911.png

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.

vxiaotang_1-1624356567952.png

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.

Fowmy
Super User
Super User

@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" )



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.