I am facing an issue in the Slicer filter list display where the value is for example L & B Equity, which is displayed properly in the table, report layout.

However in the Slicer it shows L&B Equity.

Any idea how to resolve the issue !!!

@Abdel Bouakline, FYI

Just now I tried to reproduce this issue (on V11 and V12) but I see ampersand symbols as expected, instead of &

You may want to post a screenshot or consider opening an Apptio Support ticket if the issue persists.

Hello Christopher, thank you for your response.

Here is the data how it is displayed in the table where L&B Equity and other with & symbol is present.

Here is what I get in the slicer..

How is the slicer column being generated? It contains single values, but the table contains multiple values combined together with commas. Perhaps something about the slicer column formula is causing the issue.

Hello Christopher here is the answer. I have column A containing all values separated by comma & column B is a formula column A=SplitEx(B,",")

As shown below the formula generated values looks good in the table.

However when refer to this column to fill the slicer, the list displayed in my previous comment contains &

Regards,

Kalyani

sorry for the formula typo its  B=SplitEx(A,",")

I agree with Christopher, it looks like the data table and the slicer are using different columns.  I would check the slicer column in the data table (not the data table on the report, but the underlying data table being used for the report), my assumption is that the data is showing the &amp and that is has nothing to do with being used in the slicer.

Hello Emily, I have just one table where this formula column is created and I am referring to the same field in the slicer

Not sure what's causing the issue. Apptio Support may be able to troubleshoot further if you decide to open a ticket.

I tried to replicate your result:

ItemsSplit = SplitEx(Items,",")

...but both normal and compact slicers showed & instead of & as seen below.

Thank you Christopher. I have done exactly the same what you just explained.

I would reach out to Apptio Support with a ticket.

Kind Regards,

Kalyani

Let us know what they say, I'm curious to hear the answer.