Forum Discussion
Textfield for several pages with variable part
I have several different reports in Power BI that I create on a quarterly basis. I created the titles of most of the pages with a text field. However, I have to manually change each new quarter number. In the following year also the year. Is there a possibility to change the year and quarter in this text field once across all pages?
Thanks!
Adem Akyüz
Hi nuovo2
I am not sure what your text field looks like , because you did not provide relevant data .
If you want to change the quarterly number at one time ,maybe you can create a measure like this :
Qty = INT(FORMAT(TODAY(),"q"))
The return value is the number for the quarterly of the current date .
The effect is as shown :
Then you can combine this number and text to form a new mark .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
nuovo2 , Sync slicer is the option you can explore
You can create a column like this to select current qtr always
Switch( True() ,
format(today(), "YYYY - \QQ") = [Qtr Year] , "This Qtr",
[Qtr Year]
)
Hi
thank you for the quick reply. But I did not understand the necessary steps to be done.
Hi nuovo2
I am not sure what your text field looks like , because you did not provide relevant data .
If you want to change the quarterly number at one time ,maybe you can create a measure like this :
Qty = INT(FORMAT(TODAY(),"q"))
The return value is the number for the quarterly of the current date .
The effect is as shown :
Then you can combine this number and text to form a new mark .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
