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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
83 | |
76 | |
64 |
User | Count |
---|---|
142 | |
112 | |
98 | |
98 | |
94 |