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.
Hello,
I've been trying to reproduce the table of this link, but unfortunately I am not able to create the red/green/yellow bullets and I cant see the Retail Analysis Sample in my power BI version. I'd like to create bullets as below:
I have seen examples in where people create columns with "URL icons", by creating a new table with a correlation between Column A (numbers) & Column B (icons from URL), but what I need is something like an excel rule in which if table column contains 1 then shows a green icon and if cointains a 0 a red icon.
Can someone help me? Thanks in advance.
Solved! Go to Solution.
HI @jgo1986 ,
You can add a calculated column with unichar function to display symbol icon, then you can enable conditional formatting on it to display different color based on other fields.
Icon = UNICHAR(11044)
Regards,
Xiaoxin Sheng
HI @jgo1986 ,
You can add a calculated column with unichar function to display symbol icon, then you can enable conditional formatting on it to display different color based on other fields.
Icon = UNICHAR(11044)
Regards,
Xiaoxin Sheng
Thanks a Lot,
Worked fine. As I had 3 possible values (0=Black, 1=Green; 2=Red), a lot of KPIs (Rows) and 12 Months(columns), what I did was to convert the text columns to number, then I created another 12 month columns = Unichar (11044) and then I created a Table Visual and applied for each new icon month_column the following steps:
Thanks a lot 🙂
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 |