Get Rid of Count Of in Card to make a Chart Title

[marcelita03]

I have been trying for hours with no luck

I want to have a dynamic title in my chart

I have a slicer ...so when I select the company ID Number in the slicer, I want the title of my chart to be the company NAME

I have researched a lot and see most people hae used "Cards" to accomplish that

Problem is....  the card shows "Count Of" instead the actual Company Name. Somehow the card treat all fields as values

So instead of IBM ....or PEPSICO... I see "Count of Companies 2"

Is there a measure I can create to trick the card into showing me the field TEXT?

Or have anyone found another way to work with dynamic titles for your chart?

[Vvelarde]

@marcelita03

Try this with a Card.

Put the measure in a card Visual

[marcelita03]

I created the measure just like yours only comas instead of colons (comas en lugar de punto y coma)

Didnt work. Now it doesn't show "count of" but a big "Blank"

When I bring the card shows blank... 😞

How did you make yours to work?

[Vvelarde]

Can you send me this test file to make a review.

[marcelita03]

sure!

How do I get it to you? email?

I don't see an option here to attach the file...

[Vvelarde]

Upload to DropBox or Drive or OneDrive and share the link.

[marcelita03]

Here is the link Victor. Thanks!

Let me know if you can see it

file://DESKTOP-NI1VMRH/Users/atile/OneDrive/Test%20BI

[Anonymous]

Hi @marcelita03,

Since I can't open the link, can you fix it?

Regards,

Xiaoxin Sheng

[marcelita03]

No.  I have tried everything. No luck

[Anonymous · Accepted solution]

Hi @marcelita03,

You can follow below steps to get the select company name.

Data table:

 

Write the measures to get select item.

Select Name(one) = if(HASONEVALUE(Sheet1[Company ID]),VALUES(Sheet1[Company Name]),BLANK())

All Select Item = CALCULATE(LEFT(CONCATENATEX(Sheet1,Sheet1[Company Name]&","),LEN(CONCATENATEX(Sheet1,[Company Name]&","))-1) ,ALLSELECTED(Sheet1))

Create visual s:
Slicer:
 

Cards:
 

Notice:
“Select Name(one)” only works for select one value, if you choose multiple items, it will be blank.
“All Select Item” will get all names which you selected in slicer. 
If you haven’t choose an option, “Select Name(one)” card will display blank, “All Select Item” will show all of the item name which in the sheet1.

In addition, if you not want display the measure name, you can turn off it at “format” tab -> “Category label”.

 

Regards,
Xiaoxin Sheng