Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Can I change the text in a card based on the value of a measure? Specifically , I am calculating the variance between 2020 and 2021 for Income tax. In the tables below you can see the variance between 2020 and 2021 for income tax is -200... (800 -1000= -200). I would like to have a card that dynamically changes words based on the variance. If the variance is positive I would like the card to say Increased income tax. If the variance is negative I would like the card to say decreased income tax. Is there a way to accomplish this?
2020 | |
TaxType | Amount Paid |
Income Tax | 800 |
vendor tax | 300 |
state tax | 400 |
Other | 1000 |
Total | 2500 |
2021 | |
TaxType | Amount Paid |
Income Tax | 1000 |
vendor tax | 300 |
state tax | 400 |
Other | 1000 |
Total | 2700 |
Solved! Go to Solution.
If you're happy to do it in the card 'Title' then yes.
See gif below.
Let me know if you have any questions.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
If you're happy to do it in the card 'Title' then yes.
See gif below.
Let me know if you have any questions.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
User | Count |
---|---|
96 | |
87 | |
78 | |
73 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |