DAX How to check if text contacts strikethrough

[Anonymous]

Hi there,

Does anyone know if there is a way to filter out rows where the text contains strikethrough (line across text / crossed out text)?

My query source is excel sheet.

Thanks!

[Jimmy801]

Hello @Anonymous 

have you been able to solve the problem with the replies given?

If so, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

All the best

Jimmy

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Based on my test, If I import the data with strikethrough in power bi desktop. We cannot get it as the picture below.

Also it is not supported to set the font of the data in power bi currently. You can come up a new idea and add your comments there to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

[ImkeF]

Hi @Anonymous ,

if you're desparate to get this information (and have a bit time and patience to your hands), then you could go down the rabbithole and retrieve this information from the parsed xml-files. In the function mentioned here : https://www.thebiccountant.com/2017/08/18/how-to-import-from-excel-with-cell-coordinates-in-power-query-and-power-bi/  you find the way how to extract the xmls using Power Query. But then you'd have to find your own way to the formatting data and match that back to the values that the native connector imported. 

But this might be a lot of work...

[Jimmy801]

Hello @Anonymous 

there is no way to read the format of a cell. It reads only the content of the cell, not the property. The only way you solve this is to implement a conditional formatting in Excel, that does formatting according to a cell value and then read the cell value in Power BI.

Hope this helps

Jimmy