Excel treats attribute-numbers different than a measure

[Anonymous]

This might not be a DAX kind of question, but more of a Excel question and if I'm posting on the wrong thread I'm sorry and you can direct me to the right one.

This is just something I would like an answer to. The customer is saticefied so all's good.

But here is my struggle:

I have gotten a bit of trouble with my tabular model. I have a customer where we have had to take two different kind of costs and add as attributes to our Project dimension. They are called InitialKostnad (=Initial cost) and SenastRevideradKostnad (=LatestRevisedCost).

Here's how it looks in Visual Studio:

Nicely formatted as we would like it to look. Thousand separator (the Swedish way) and no decimals. In my tabular model I set the properties Whole number (format and datatype). But when I do a pivot-table in Excel it looks like this:

So it feels like it takes a more "international" look. And in the pivot-table I cant format the cells to look like the image above. And, my customer is a Swedish company, so I would really like to get them a "Swedish" look of the numbers. 

My regular measures are formatted in the pivot-table as they should be, just that this numbers are attributes to a dimension and somehow they behave in a different manner.

So is there anybody that has an idea of what's going on, and how I could fix it?

Thanks in advance!

Cheers!

/Peps

[lbendlin]

What's preventing you from creating measures from these attributes?  Excel needs measures in pivot table value wells anyway.

[Anonymous]

@lbendlin Well, the formatting would work if I create measures of them, how ever these numbers should only be displayed once, in front of the monthly values. If I have them as a measure, the will be repeted every month.

[lbendlin · Accepted solution]

You could either hard code the swedish format in your data source (converting the attributes to text)  or you could engage in column width and word wrap trickery to show the measure value only once.