Analyze in Excel - Calculation groups formating not available

Hello v-yanjiang-msft ,

Thanks for your answer. 

I'm not sure we talk about the same issue, maybe I was not very clear, so I will just add few precisions :

- I don't try to import a report / a visual in Excel to have the same formating as in Power BI

- I have a calculation group in my dataset that have a "dynamic" formating. Depending on the currency I filter on, the formating is not the same (if I select the currency "EUR", i can see the "€" symbol ; if I select the "DOL" currency, I can see the "$" symbol).

- To enable the dynamic formating, I use the Format String Expression property of the calculation group, which seems to be not applied when I'm in Excel and I retrieve my data diretcly from my dataset. However, if I use the DAX formula Format(), the formating is applied in Excel but numbers are considered as text so it's not possible to make calculations from them.

Unfornutatly, the solution your proposed is not working in my case, because I would like the dynamic formarting to be applied when a user create an Excel report from scratch directly from my dataset.

Thanks in advance for your help !