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 ,

 

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

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

    Hi setis ,

     

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

     

    Thanks,

    Pragati

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

      Pragati11 , I created it using tabular editor..