Forum Discussion
Power bi
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 attachedIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
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 attachedIf 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
