This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Hi, which measure can i use in Power BI Desktop if the text in a table is empty, than use another use another text?
Column = COALESCE('Table'[PO],"Replacement Text")
Hi,
Can you expand on this a bit more and maybe post some sample data? It sounds like you just want to use an IF statement in your measure to show one field but replacement text if it's blank. if so something like the below should work:
IF(ISBLANK('Table'[Field]),"Replacement Text", 'Table'[Field])
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi, thank you. But with this formule i can select only measures and not tables. Do you know how to select a table with this measure?
You could use a calculated column to select table fields instead of a measure
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 32 | |
| 26 | |
| 23 | |
| 22 | |
| 15 |
| User | Count |
|---|---|
| 63 | |
| 45 | |
| 28 | |
| 24 | |
| 22 |