Analyze in Excel - Calculation groups formating not available

[Anonymous]

Hello everyone,

I have a Power BI dataset that contains calculation groups. In these calculation groups, there are conditional format expression that are applied, which work in Power BI reports. However, when I use "Analyze in Excel" feature to see the data, I'm not able to see the dynamic formating of the calculation groups.

Does anyone have a clue about how to solve / bypass this issue ?

Thanks for your help !

[phbronson]

Any update yet?

Do you know if this problem exsist with calculation group created in Power BI?

In 2022 you would have created these in Tabulor editor, I wonder if the issue persist in a newer update of PBI?

[Anonymous]

Up - Still not solved

[Anonymous]

Up

[Anonymous]

Up

[Anonymous]

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 !

[v-yanjiang-msft]

Hi @Anonymous ,

With Analyze in Excel, you can only bring Power BI datasets into Excel, not the report. Conditional formatting is for report, but not the datasets. 

Here's a article about applying conditional formatting to a Pivot Table in Excel for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.