report with one base measure but different format

[jvandyck]

I am stuck on a scorecard report I am building. I have isolated the problem in the attached report you can find through the link at the bottom.

Basically there is an indicator dimension and a fact table with a value per indicator per month.

Some indicators should be shown as a percentage and some as a value. The final report shows multiple columns: MTD, YTD, MoM change %, YoY change %, % target MTD, % target YTD.

I now fixed it using a calculation group with a calculated item per indicator. In the attached report, this results in the calculation group "Indicator formating".

This approach worked fine in the full report, but now I get the error message "This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed." The full report should show about 70 indicators in a table with 10 columns.

Is there a more intellegent way to show the different formats in my example, generating less calculations?

Link to the mock-up: https://acerta-my.sharepoint.com/:f:/g/personal/joos_van_dyck_acerta_be/Es6D9qaHjD9FvNOm2I5HMKgB3MEk... 

[jvandyck]

Thank you @Anonymous ! On my mock-up it already works....we will try it on the real scorecard report!

[Anonymous · Accepted solution]

Hi @jvandyck ,

Please try to create dynamic format for measures.

For more details, you can read related document: Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.