how i can change format in the below column named last 5 to look like pcitue i tried conditonal formating but doesn't work
Hi @MUtasem
Unfortunately, with Power BI Core Visuals, there is no built-in functionality to style each individual character differently within a single cell.
To achieve a similar result, you would need to manipulate your list, including splitting the values into separate columns.
The final table should look like the one in the image:
and from there, you can build a Matrix Visual with conditional formatting in a similar style.
However, the formatting will still be different – without rounded edges or advanced visual effects.
Advanced Alternative:
If you need full control over the design, you might be able to achieve this using:
🔹 Deneb – A custom visual based on Vega-Lite that allows advanced formatting.
🔹 HTML+SVG – Creating a custom visual using HTML or SVG to display text and colors.
🔹 Python/R – Using Python Visuals or R Visuals to build graphics that mimic the desired design.
The pbix with transformations of table with PQ to get the needed format
and creating the matrix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @MUtasem
Unfortunately, with Power BI Core Visuals, there is no built-in functionality to style each individual character differently within a single cell.
To achieve a similar result, you would need to manipulate your list, including splitting the values into separate columns.
The final table should look like the one in the image:
and from there, you can build a Matrix Visual with conditional formatting in a similar style.
However, the formatting will still be different – without rounded edges or advanced visual effects.
Advanced Alternative:
If you need full control over the design, you might be able to achieve this using:
🔹 Deneb – A custom visual based on Vega-Lite that allows advanced formatting.
🔹 HTML+SVG – Creating a custom visual using HTML or SVG to display text and colors.
🔹 Python/R – Using Python Visuals or R Visuals to build graphics that mimic the desired design.
The pbix with transformations of table with PQ to get the needed format
and creating the matrix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
@MUtasem how does raw data looks like? Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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.
Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
