Different formatting of data value in different charts

[KAITHA]

Hi PBI community,

May I know if i can format the data value differently in different charts? for example in below screenshot, I would like to keep $ in KPI charts for actuals and budget figures. However, I'd like to remove $ from actuals and budgets figures from bar charts as it is taking up unncessary spaces. Currently, once i format the actuals and budget figures columns in data source to currency, the same format is applied to both KPI and bar charts - either to keep or remove $.

Is there any way to remove $ from bar charts but to keep $ in KPI charts? Thanks. 

[MFelix · Accepted solution]

Hi @KAITHA ,

You cannot make custom formatting based on the visualization you are using at least directly, what you can do is to make different measure to use on the visualizations, or create a calculated group that makes that format change based on a filter/slicer.

https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/

[Anonymous · Accepted solution]

Hi @KAITHA ,

You can use the following solutions to achieve

Because your bar chart and KPI chart are the same measure or column, you can create a new measure for the bar chart to show values without $ .

You can see the details from the attachment.

Best Regards,

Stephen Tao

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

[KAITHA]

Thanks for your suggestion @Anonymous !

[MFelix · Accepted solution]

Hi @KAITHA ,

You cannot make custom formatting based on the visualization you are using at least directly, what you can do is to make different measure to use on the visualizations, or create a calculated group that makes that format change based on a filter/slicer.

https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/

[KAITHA]

Thanks for your suggestion @MFelix !