Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
hb0135
Helper III
Helper III

To scratch a particular word or sentence in power bi

Hello,
Need a help to sratch a word or sentence in power bi like we do in excel by pressing the control +5 button then it look like 

hb0135_0-1692760295787.png

BR,
HB0135

2 ACCEPTED SOLUTIONS
v-tangjie-msft
Community Support
Community Support

Hi @hb0135 ,

 

Unfortunately, Power BI does not have a built-in feature to strikethrough text like Excel does.

But you can use custom visual objects : HTML VizCreator Cert by BI Samurai

Then we can create a measure like this:

Measure = IF(MAX('Table'[value])="abc","<s>" & MAX('Table'[value]),MAX('Table'[value]))

vtangjiemsft_0-1692864193240.png

 

Please refer to the following documents for more information.

Bold, italic, underline etc. in Power BI - BI Samurai

Bold, italic, underlined or strikethrough text in Power BI? No problem! ✔ - YouTube

 

Best Regards,

Neeko Tang

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

View solution in original post

Hi @hb0135 ,

 

If you want all data to have strikethrough, use the following measure.

 

Measure 2 = "<s>" & MAX('Table'[value])

 

vtangjiemsft_0-1692868263344.png

 

If you want specific data to have strikethroughs, create a measure with the IF function.

 

Measure 3 = IF(MAX('Table'[value])="abc" || MAX('Table'[value])= "def","<s>" & MAX('Table'[value]),MAX('Table'[value]))

 

vtangjiemsft_1-1692868292440.png

Best Regards,

Neeko Tang

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

View solution in original post

5 REPLIES 5
v-tangjie-msft
Community Support
Community Support

Hi @hb0135 ,

 

Unfortunately, Power BI does not have a built-in feature to strikethrough text like Excel does.

But you can use custom visual objects : HTML VizCreator Cert by BI Samurai

Then we can create a measure like this:

Measure = IF(MAX('Table'[value])="abc","<s>" & MAX('Table'[value]),MAX('Table'[value]))

vtangjiemsft_0-1692864193240.png

 

Please refer to the following documents for more information.

Bold, italic, underline etc. in Power BI - BI Samurai

Bold, italic, underlined or strikethrough text in Power BI? No problem! ✔ - YouTube

 

Best Regards,

Neeko Tang

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

Hello,
Thanks for the help 
what if i want for "def" and"ghi" to scratch in same measure

hb0135_0-1692866958182.png

BR & Thanks,
hb0135

Hi @hb0135 ,

 

If you want all data to have strikethrough, use the following measure.

 

Measure 2 = "<s>" & MAX('Table'[value])

 

vtangjiemsft_0-1692868263344.png

 

If you want specific data to have strikethroughs, create a measure with the IF function.

 

Measure 3 = IF(MAX('Table'[value])="abc" || MAX('Table'[value])= "def","<s>" & MAX('Table'[value]),MAX('Table'[value]))

 

vtangjiemsft_1-1692868292440.png

Best Regards,

Neeko Tang

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

Hello,
Thanks for your previous help using HTML visual to strike through option but my requirment is like this mention below can you help me in this

hb0135_0-1693544530184.png

BR 
HB0135

I want to echo this question. How is it that strikethrough, a very common text editing feature, is not available in Power BI?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.