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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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