Forum Discussion
Text box Formula
Hi,
I wanted to know if there is a formula that I could use in the text box that would update the text to say QTR 1, 2, 3 or 4 based on the months or quarter given by the parameters?
walker8888 ah! That you can surely create using a measure, yes it can be dynamic:
Title Measure = VAR __SelectedQuarter = SELECTEDVALUE ( YourTable[YourColumn] ) RETURN "Monthly Break Down " & __selectedQuarterwalker8888 you can use card visual and put this measure in that visual.
6 Replies
walker8888 ah! That you can surely create using a measure, yes it can be dynamic:
Title Measure = VAR __SelectedQuarter = SELECTEDVALUE ( YourTable[YourColumn] ) RETURN "Monthly Break Down " & __selectedQuarterSilly question, but how would I put it in the textbox?
walker8888 you can use card visual and put this measure in that visual.
If I wanted to add to the Measure the TY also what should I add to it?
walker8888 I guess you are referring to column headers, if that is the case, unfortunately, you cannot set these dynamically.
Thanks for responding, I am talking about the text box
