Forum Discussion
Color change for specific text in card visual
- 3 years ago
Hi Composed_MS
When faced with these situations, I tend to reach for a simple solution that just works.
Uses a text box to combine two cards and apply conditional formatting rules.
As follows:1.The text box is prepared and places where cards will go. I just type a string of strings that will save me space for the cards according to their maximum character limit:
2. Creating each card with its conditional format, white background and cleaning everything that takes up space, and changing the border padding to eliminate white spaces
3.I attach the cards to the places I saved them once they are designed
4. Grouping all created "construction"
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
I am using the whole line as a single measure, which is dynamic according to selection.
In measure, I wrote it using & operator so that my text gets concatenated.
Increase and decrease are dynamic which I coded in the measure itself.
So in that measure for these two numbers I need to color code and other words should remain black colored only. AmiraBedh
Can you please share your pbix file ? or at least the code of your measure?
- Composed_MS3 years ago
Helper I
Measure->
"TO has "
&
SWITCH([TO CY vs PY],
"#71CE0D","increased",
"#E80054","declined")& " by " & FORMAT([TO CY vs PY],"Percent")
& " and there’s an " &
SWITCH([head CY vs PY],
"#71CE0D","increment",
"#E80054","decrement")&" of " & FORMAT([head CY vs PY]*100,"0.0") &"bps in headcount percentage from "& [Vs PY Quarter]