Forum Discussion

setis's avatar
setis
Icon for Post Partisan rankPost Partisan
5 years ago

Title format on a visual

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" ...
Need Help
setis's avatar
setis
Icon for Post Partisan rankPost Partisan
5 years ago

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

 

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

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's avatar
    setis
    Icon for Post Partisan rankPost Partisan
    5 years ago

    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's avatar
      Pragati11
      Icon for Super User rankSuper User
      5 years ago

      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