Title format on a visual

[setis]

I'm using a measure to format a title on a visual based on a slicer. 

The measure is:

KPI_Title = 
VAR Selected_KPI = SELECTEDVALUE(Performance_Measures[Name])
RETURN
Selected_KPI & " by month"

The issue is that the name of one of the selections is "Absence paid %" and when I select this one, I get the error: "Cannot convert value 'Absence paid % by month' of type Text to type Numeric. 

How can I format the SELECTEDVALUE in the measure above to avoid the error due to the "%" symbol?

Thanks in advance

[Pragati11]

Hi @setis ,

You can try modifying your DAX as follows:

KPI_Title = 
VAR Selected_KPI = SELECTEDVALUE(Performance_Measures[Name])
RETURN
FORMAT(Selected_KPI, "Standard") & " by month"

Thanks,

Pragati

[setis]

@Pragati11 thanks for your answer. Unfortunately, it didn't make the trick. I still get the same error.

[Pragati11]

Hi @setis ,

Do you mind sharing all the options you have in your slicer - Name?

Also what all fields are you moving to the visual giving error?

[setis]

@Pragati11 sure! The options are these:

There are more but the format is the same. 

I'm using a calculate group and the slicer to plot the results into a Line chart. 
I'm using Months from my date table as x axis, "Name" from the calculation group as Legend and my selectedmeasure() as values. 
When I select a calculation item without the "%" works fine.

[Pragati11]

Hi @setis ,

What is the datatype of NAME column? Has it got any null values in it?

I just tried to create concatenated value using the test values at my end and it works fine.

I don't see the issue because of % sign in the values.

My column's datatype is TEXT. See below:

Now if I create a similar measure as your's:

And then check slicer selection:

It looks like it works at my end.

Can you attach screenshot fo the Line chart that you are generating or may be a sample pbix file with the issue? I want to understand how you are using NAME column on your line chart. is it summarised to show COUNT, Count(Distinct), etc. ??

Thanks,

Pragati

[setis]

@Pragati11 Thanks for your effort. Please find the file here: https://drive.google.com/file/d/1F3-43NIXU2igxlCYg_Ki-sAhDbrpGXpy/view?usp=sharing

The error shows up when selecting "Sales %" in the slicer

[Pragati11]

Hi @setis ,

this is about calculation groups. How is this calculation group created? Is it coming from SSAS (tabular) model?

Thanks,

Pragati

[setis]

@Pragati11 , I created it using tabular editor..