Empty Space before bullet points while converting HTML to text IN REPORT BUILDER POWER BI

[Chetan----]

I have data in sql server ,There is one column which has HTML Tags ,

I have taken on table visual and and added filter to and and added HTML Tags column in cell of table and did "HTML - Interpreter tags as a style".Then When I run the report these gives thes output--

In these the problem is Before bullet points it has some space .I want bullet should start from extreme left of that box.I do not know what is the reason behind it.I have made padding to "0pt" for left and made left Alignment of text  but still it keeps blank space before the bullet.Can anyone help me with it.

For the above Text box ,These is the column with HTML tags as shown below --

<ul> <li style="text-align: left;">Cyclicality</li> <li style="text-align: left;">Historical Financial Performance / Recent Margin Ramp</li> <li style="text-align: left;">Competitive Differentiation</li> </ul>

[Chetan----]

Do I have to make changes in HTML source?

Or can It be done by via sql server by using replace function etc...(I tried using replace finction,adding CSS style start from left via sql server but it did not work.

[lbendlin]

both options should work.

[Chetan----]

Can u please suggest me In the below HTML Tag,what needs to be replaced via sql query to remove blank spaces before the bullets--

<ul> <li style="text-align: left;">Cyclicality</li> <li style="text-align: left;">Historical Financial Performance / Recent Margin Ramp</li> <li style="text-align: left;">Competitive Differentiation</li> </ul>

[lbendlin]

looks like the div is playing games with you.

html - How can you left justify list items in a unordered list that is centered within a div? - Stac...

[Chetan----]

SELECT
*,
REPLACE(commentary, '<ul>', '<ul style="text-align: left; margin: 0; padding: 0;">') AS UpdatedCommentary
FROM x

here I tried adding CSS but still there is blank space before bullet exist?

[lbendlin]

That's the way list items render by default.  Use CSS to modify that behavior.