Exporting Matrix Table with Dynamic Formatting Throwing an Error in Excel

Hi Caitlyn,

I am using Version: 2.138.1452.0 64-bit (November, 2024). 

As an example, I have a file with sales data, by sales person, product ID  and the sales amount, shipping amounts etc. I'm trying to produce the matrix table below.

The matrix table has 12 measures showing metrics broken down by the sales person where the amounts are formatted dynamically in "$k, $M, and $B" in this case. (The data is masked and I've created dummy table to mimic my actual data). 

When I export the matrix table in purple, I get the error saying there's a problem with some content in the file. If I remove the dynamic formatting from the measures (so the amounts are shown without the "k", "M", or "B"), I don't get the error.

I can share the pbix file if needed.