Tag expansion in the PBI report doesn't work when there are special characters

[ljimenez712]

🐛 Problem

Tag expansion in the PBI report doesn't work when there are special characters. Example tag which fails to expand: eg:tag-name

👣 Repro steps

In step 1 in the PBI report add a tag with the problematic format

🤔 Expected

TODO: Add a clear and concise description of what you expected to happen.

📷 Screenshots

TODO: If applicable, add screenshots to help explain your problem. Remove if not applicable.

ℹ️ Additional context

TODO: Add any other context about the problem here. Remove if not applicable.

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Leave comments to help us solidify the vision.

[flanakin]

I can't replicate or test this right now, but I'm guessing this is because column names can't have colons.

ljimenezelite (@ljimenez712) Can you try this and see if it works? Find 2 instances of Text.Replace(_, " ", "") in the Costs query and replace them with Text.Replace(Text.Replace(_, ":", "_"), " ", ""). This will create a column name with underscores instead of colons. If you'd rather not have underscores, you can remove the underscore from "_".

Let us know if that works and what your preference is for with or without underscores when we get a chance to ship a fix for this.