How to change the format to currency in slicer?

[hollyanneu2]

Hi -

For the life of me, I cannot find a way to change the format to currency in a slicer....Please help!

 

[Skovgaard]

I just tried to replicate and I got below.
The number format in the source table, was set before creating the Pivot and Slicer.
Did you do the same?

/Skovgaard

 

[hollyanneu2]

I just tried to replicate and I got below.
The number format in the source table, was set before creating the Pivot and Slicer.
Did you do the same?

View attachment 75012

/Skovgaard

Did you push the raw data into the Power Pivot or classic Excel Pivot? I had to push the raw data into the Power Pivot.

Let me try in the classic pivot and see if it works as well as filtering...

 

[hollyanneu2]

I just tried to replicate and I got below.
The number format in the source table, was set before creating the Pivot and Slicer.
Did you do the same?

View attachment 75012

/Skovgaard

It works but does not do anything for the table on the far left as not connected....the one with the lack of format in the middle works because it's connected to the data in the power pivot...

 

[Skovgaard]

I just did the test in classic pivot, but I guess it should do the same.

I've testet with Power Pivot and I see the same as you.
The only way I can make it work, is if my original data is formatet as text, with the currency symbol as a part of this.
Below is a result of this, in power pivot.

Maybe others have a better solution?

/Skovgaard

 

[hollyanneu2]

I just did the test in classic pivot, but I guess it should do the same.

I've testet with Power Pivot and I see the same as you.
The only way I can make it work, is if my original data is formatet as text, with the currency symbol as a part of this.
Below is a result of this, in power pivot.

Maybe others have a better solution?

View attachment 75123

/Skovgaard

Strange, mine is in currency format...see the original post as you can see that it was in Currency format in the pivot table...how did you manage this that I may have missed a step?

 

[Skovgaard]

How does the your formula line looks like?
See below, I had to add the $-sign and make it to a text to make it work.

/Skovgaard