This week during Avi’s Power BI “Let’s talk Power BI” and the internal Power BI Office Hours I heard the question “How do i get excel like stop lights in my Power BI Report”
If black and white “images” will work you might check out my earlier post:
https://blogs.msdn.microsoft.com/charles_sterling/2017/02/10/status-icons-in-power-bi-tables/
If you just need to display images please check out the Chiclet Visual: https://app.powerbi.com/visuals/show/ChicletSlicer1448559807354
Now During the Office hours the person Just needed the color…The specific shape wasn’t terribly important.
In that case Conditional Formatting can be used.
Step 1: Add a table Visual with the columns you want to display and the column used for the colors
Step 2. Set conditional formatting on the column you want for the colors
Step 3. Collapse the “color” column down to just display the color –not the value
Hope this helps!
Chuck
This post first appeared on MSDN Blogs | Get The Latest Information, Insights, Announcements, And News From Microsoft Experts And Developers In The MSDN Blogs., please read the originial post: here
