Forum Discussion

nuovo2's avatar
nuovo2
Regular Visitor
5 years ago
Solved

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 numbe...
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.