Forum Discussion
walker8888
2 years agoHelper II
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?
- 2 years ago
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 " & __selectedQuarter - 2 years ago
walker8888 you can use card visual and put this measure in that visual.
parry2k
2 years agoSuper User
walker8888 I guess you are referring to column headers, if that is the case, unfortunately, you cannot set these dynamically.
walker8888
2 years agoHelper II
Thanks for responding, I am talking about the text box