Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Thanks to all who respond.
I need help creating this measure: I have 3 cards showing totals for 2021, 2020, 2019. I would like to have the font color change to red or green based on the previous year total. So if year 2020 amount was greater than 2021 change to 'red', if less than change to 'green'.
Table name = 'Sheet1'
Field name = 'Amount'
Field name = 'YEAR'
Any ideas?
Thanks-BLD
Solved! Go to Solution.
You'll need to use a different KPI Card visual. There are a few options in AppSource.
You could create your own card visual using Smart Narratives:
And change the colour of the font using this trick:
Smart Narratives and Conditional Formatting in Power BI? Yes please! - Guy in a Cube
Proud to be a Super User!
You'll need to use a different KPI Card visual. There are a few options in AppSource.
You could create your own card visual using Smart Narratives:
And change the colour of the font using this trick:
Smart Narratives and Conditional Formatting in Power BI? Yes please! - Guy in a Cube
Proud to be a Super User!
Thank you, great idea.
BLD
@Anonymous HI,
We cant dynamically change the font colour using Card, instaed use table for each value and you need to create 3 different measures where you need to use switch statement dax1 > dax2 then "Hex code of Red" like that..
Regards,
John Basha Mattipati,
https://www.linkedin.com/in/john-basha-mattipati-06812980/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |