Forum Discussion
Solved
Using custom Format string turns measure into text, does not work with Excel analyze
When changing the format of my measure to a custom string - I want to display in millions, with one decimal and add "M" at the end - it seems like PowerBi interprets the measure as text. In Analyze i...
That is correct, and working as designed. You can create a duplicate of the measure but without formatting. Use that for your Analyze in Excel needs.
That is correct, and working as designed. You can create a duplicate of the measure but without formatting. Use that for your Analyze in Excel needs.