Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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! |