Thousand separator and decimals in BI charts

[ashvinc]

Hi,

Say there is a Bar Chart and a filter being selected so that the bar chart displays a highlighted and a non-highlighted data.. When we hover the mouse over it.. it shows the actual value of the raw data in both highlighted and non highlighted data.. Is there an option where the data for example 1493757.23 would show as 1.5M or 1,493,757? 

[Greg_Deckler]

In the model, select the column and in the Modeling ribbon, click the "," button and reduce the decimal points to 0. That will get you the latter. I believe the only way to get the former would be to create a custom column and get it formatted the way you want as text and then add it to the details area.