Forum Discussion
Table Highlight in Desktop
- 5 months ago
ahmedshalabyy12
That kind of highlight is done using SVGs.
Please take a look at these YouTube links:
https://www.youtube.com/watch?v=7MoZ7NHBijE
https://www.youtube.com/watch?v=PvwoDKM_dvQ
I hope this helps, if so please mark it as a solution. Kudos are welcome. - 5 months ago
hello ahmedshalabyy12
Natarajan_M is straightforward which you can try it first.
as pcoley said, this should be possible by using svg.
however, this is a workaround if you want to have those customized icon instead of font and background color as explained by Natarajan_M and without using SVG as explained by pcoley .
1. put all your customized image icon in a folder (you can do a local folder).
2. import those image to power bi (get data->folder). then define the image which for what condition.
3. transform that image into base64
= Table.AddColumn(#"Removed Other Columns", "Custom", each "data:image/png;base64, " & Binary.ToText([Content], BinaryEncoding.Base64))
4. import to power bi
5. create a calculated column to calculate the base64 code based on your fact table condition and DONT forget to change data category into Image URL.
Image =
MAXX(
FILTER(
'IMG',
'Table'[Promo Tier]='IMG'[Condition]
),
'IMG'[Custom]
)6. plot into table visualHope this will help.
Thank you.
- 5 months ago
That uses a dax generated SVG. You can ask AI to generate it for you.
Please see the attached pbix
Hi ahmedshalabyy12 , We can recreate this using the conditional formatting in power bi .
Sample Data :
Measures : we are going to create a measure to get the currentvalue of the promo and discount and based on the value it will show the background and font color
Measures for Background color :
for Font :
Thanks
If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster