changing formatting in a chart on the fly

[Anonymous]

Hi, I have a set of 5 buttons that depending on the button chosen, it populates a chart, with different measures.  The chart is setup to show the values from the measure over a time period.

4 of 5 of the measures are whole number values, ###,###,### whole number format.
The 5th is in a #.# format.

I can set the format in the chart for 4 of 5 of them.  I've been trying to change the format to "#.#" for the 5th one, but the formatting in the chart doesn't give me the option to change to different formats.

I used the DAX FORMAT command but that did not help.  It seems that whatever you set on the chart overrides any format through DAX.

IS there a way to change the format on the chart to different types depending on what numerical data is populating it?

I'm trying to find a way 

[Anonymous · Accepted solution]

Thanks very much! I know with powerbi external tools you can create calculation groups, but with the October release, can I create the calculation groups directly in PowerBI?

[audreygerred · Accepted solution]

Hello! Yes, you can. You just need to enable the feature in preview features. 

[Anonymous · Accepted solution]

Thanks much for your help. People like you make my experience in PowerBI so much better...

[audreygerred]

Hello! You can try dynamic format string for measures, or, if you create a calculation group with your measures you can format each one individually that way as well.

Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

Introducing dynamic format strings for DAX measures - SQLBI

[Anonymous · Accepted solution]

Thanks very much! I know with powerbi external tools you can create calculation groups, but with the October release, can I create the calculation groups directly in PowerBI?

[audreygerred · Accepted solution]

Hello! Yes, you can. You just need to enable the feature in preview features. 

[Anonymous · Accepted solution]

Thanks much for your help. People like you make my experience in PowerBI so much better...

[audreygerred · Accepted solution]

You are very welcome! I am happy I could help! If my answer solved your issue, please consider marking it as a solution so others may benefit from it in the future.