Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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?
Can you send me this test file to make a review.
sure!
How do I get it to you? email?
I don't see an option here to attach the file...
Upload to DropBox or Drive or OneDrive and share the link.
Here is the link Victor. Thanks!
Let me know if you can see it
file://DESKTOP-NI1VMRH/Users/atile/OneDrive/Test%20BI
Hi @marcelita03,
Since I can't open the link, can you fix it?
Regards,
Xiaoxin Sheng
No. I have tried everything. No luck
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |