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

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'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.