Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Team,
I need a create a Text Card, which needs to show the selected values in a single column, please help me on this
Solved! Go to Solution.
Is using a measure like @jgeddes show you before.
The measure is this:
NameSubCateg = CONCATENATEX(T_SubCateg,T_SubCateg[SubCategory], " | ")
T_SubCateg is my table and SubCategory is my column.
Proud to be a Super User!
Hi @JothiKrishnan ,
Did @_AAndrade reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.
Best Regards,
Adamk Kong
You can create a comma delimited list with...
SelectedColumns =
CONCATENATEX(
VALUES('Table'[item]),
[item],
", "
)
where 'item' is the name of the column with your values in it.
Proud to be a Super User! | |
@jgedde - Thank you for your assistance. The data I intend to use are in the same column, not a separate one. The column I require contains 1000 rows with distinct fields; I only need certain fields to be displayed as a KPI in the card view.
Ok. If you can share some data, or some dummy data that shows the baseline as well as your desired result it will be easier to provide a valid solution.
Proud to be a Super User! | |
Please Share same data and the desired output to clear understand your request.
Proud to be a Super User!
I've attached two images: the first one displays the total number of sub category list, and the second one displays the list of sub cateogiry. However, my scenario is for the text chart to display only the number of selected sub category, so in order to visualize it, I need to extract only the relevant sub category list from the selected column with out using slicer.
I've attached two images: the first one displays the total number of sub category list, and the second one displays the list of sub cateogiry. However, my scenario is for the text chart to display only the number of selected sub category, so in order to visualize it, I need to extract only the relevant sub category list from the selected column with out using slicer.
Like this:
In my example I only have 6 subcategories.
Proud to be a Super User!
Yes, how u did that, please help me on this
Is using a measure like @jgeddes show you before.
The measure is this:
NameSubCateg = CONCATENATEX(T_SubCateg,T_SubCateg[SubCategory], " | ")
T_SubCateg is my table and SubCategory is my column.
Proud to be a Super User!