The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
how i can change format in the below column named last 5 to look like pcitue i tried conditonal formating but doesn't work
Solved! Go to Solution.
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
I would add an index column, split the letters in to rows and generate svg images using DAX for each letter to achieve the rounded corners.
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.