I can't select Card Title from a created table

[Syndicate_Admin]

Hello I have two cards and I want that according to the year you select appears in the title of the card in this way:

As you can see With one of the cards without problems, selected the annuity attribute from the table.

 

but for the other card I have created a table of years, and when doing the same, it does not let you select the annuity field, it appears as blurred instead of bold:

 

 

The case I have created another table of months in the same way and if I let select the month. any idea where the problem is?

Greetings and thanks.

[Icey]

Hi @Aguirre ,

Please create a measure like below and then use the measure instead of columns.

Measure = SELECTEDVALUE ( 'Anualidad'[Anualidad] )

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Hello, I created the measure:

Year2 = SELECTEDVALUE(Annuity[Annuity])

but it won't let me select, as I mentioned it's a table with years created directly in Power BI.

The new measure works perfectly on a card but I want to put it in the Title of the card.

Thank you

[Icey · Accepted solution]

Hi @Aguirre ,

I found that! This is a limitation. 

---

• The field you create for the title must be a string data type. Measures that return numbers or date/time (or any other data type) aren't currently supported.

 Reference: Expression-based titles in Power BI Desktop # Limitations and considerations

---

Therefore, create a measure like so:

Measure = CONVERT(SELECTEDVALUE(Anualidad[Anualidad],2021),STRING)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Hello, it works perfectly for me. Just one last doubt, about a measure, since I'm not very adept at DAX, "2021" what is it used for?

[Icey]

Hi @Aguirre ,

I set "2021" as the returned value when nothing is selected in the slicer. If don't set it, it will show "BLANK()" by default. Just set it according to your needs.

---

PARAMETERS

Term	Definition
columnName	The name of an existing column, using standard DAX syntax. It cannot be an expression.
alternateResult	(Optional) The value returned when the context for columnName has been filtered down to zero or more than one distinct value. When not provided, the default value is BLANK().

Reference: SELECTEDVALUE function - DAX | Microsoft Docs 

---

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

OK, understood.

Greetings.