PQ-PP Conditional text formatting?

[cmcreynolds]

I was just wondering if there was a way to use conditional formatting within PowerQuery or PowerPivot. Specifically, I just want a strikethrough in a simple IF statement. I'm thinking it's a "no" but I thought I'd ask here, first.

 

[Matt Allington]

Not as such. You can use Excel conditional formatting on the results in your report/worksheet. You can use KPIs inside of Power Pivot to give some icon based visualisations. And you can use some tricks to format the data you want (limited scope), but it depends on what you want to do.

What are you trying to do?

 

[cmcreynolds]

I was trying to create a column that did strike-through based on if statement.

 

[Matt Allington]

Not directly in DAX, but you can with Conditional formatting in Excel.

 

[cmcreynolds]

Yeah, it was more of a "I wonder if..." than anything. I know in PQ you can change to all caps and what not, but I didn't know if there was a specific way to do strike-through. Thanks, though.