Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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! |
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |