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.
Hi
I've a dataset as under
Type | Status |
A | Favorable |
B | Unfavorable |
C | Moderate |
I was wodering if there was a way to have 3 value boxes for each of the "Type" where the color of the boxes change depending on the status
viz. for Favorable it should change to green, red for unfavorable and yellow for Moderate
I know crds with states by OKViz does something similar but it wouldnt accept string in conditions it only accepts numeric conditions
Solved! Go to Solution.
@dollarvora
You can create a measure to assign as conditional formatting as follows and choose Field Value then the CF measure.
CF =
var _status = SELECTEDVALUE(T10[Status]) return
SWITCH(
_status,
"Favorable", "Green",
"UnFavorable", "Red",
"Moderate", "Yellow"
)
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@dollarvora
You can create a measure to assign as conditional formatting as follows and choose Field Value then the CF measure.
CF =
var _status = SELECTEDVALUE(T10[Status]) return
SWITCH(
_status,
"Favorable", "Green",
"UnFavorable", "Red",
"Moderate", "Yellow"
)
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Fowmy
Thanks a lot for your solution !
I just figured how to make it look like a box and increase the font sizes !
Hi @Fowmy ,
Thanks for your reply, but it seems like I can only conditionally format fields in a table and not in a vaue box,
Also, how do I increase the size of the cell if I were to use it as a table ?
@dollarvora card with states is your friend, just create a measure for conditions and return number value in the measure and use it for conditions.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |