Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
BR,
HB0135
Solved! Go to Solution.
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]))
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.
Hi @hb0135 ,
If you want all data to have strikethrough, use the following measure.
Measure 2 = "<s>" & MAX('Table'[value])
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]))
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.
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]))
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
BR & Thanks,
hb0135
Hi @hb0135 ,
If you want all data to have strikethrough, use the following measure.
Measure 2 = "<s>" & MAX('Table'[value])
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]))
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
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
124 | |
79 | |
49 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |