How to retain text format in Power bi dashboard

[Snagalapur]

Hi All,

How to retain text format in dashboard. I have my data table to in excel and when I bring the column into dashboard I would like to retain format.

Please suggest

[danextian · Accepted solution]

Hi @Snagalapur 

Power BI reads the text inside a file and not the formatting and neither the formula from an excel file but their results.  While you want it is not impossible, that will be a very tedious thing to do. You will have to identify which text strings are colored and what the colors will be, which ones are in bold and which ones are not using a combination of splitting by delimiters, etc. And after that, write a measure or a column that generates an html code using those split values and  use the custom html viz to render the html code. Again, it is not impossible but will be a very tedioius and complex task.

[Bibiano_Geraldo · Accepted solution]

Hi @Snagalapur ,

Unfortunately, there's now way, as mentioned by @danextian "Power BI reads the text inside a file and not the formatting", knowing that, you'll have to do the formating from scratch in your dashboard.

[Anonymous · Accepted solution]

Thanks for the replies from danextian and Bibiano_Geraldo.

Hi @Snagalapur ,

If you want to realize the effect in the picture, you can use HTML Content visual, through the combination of HTML and CSS and DAX, you can render the content in different formats.

You can learn the exact steps from this blog: Display table data in HTML Content visual - Microsoft Fabric Community

Best Regards,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[Bibiano_Geraldo · Accepted solution]

Hi @Snagalapur ,

Unfortunately, there's now way, as mentioned by @danextian "Power BI reads the text inside a file and not the formatting", knowing that, you'll have to do the formating from scratch in your dashboard.

[danextian · Accepted solution]

Hi @Snagalapur 

Power BI reads the text inside a file and not the formatting and neither the formula from an excel file but their results.  While you want it is not impossible, that will be a very tedious thing to do. You will have to identify which text strings are colored and what the colors will be, which ones are in bold and which ones are not using a combination of splitting by delimiters, etc. And after that, write a measure or a column that generates an html code using those split values and  use the custom html viz to render the html code. Again, it is not impossible but will be a very tedioius and complex task.