March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I want to create a card to display the selected values of a slicer, I created a measure in this way:
Solved! Go to Solution.
I solved in this way:
@arimoldi
SELECTEDVALUE has a second parameter to show if the value selected is more than one of nothing is selected. Use your measure as follows:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks,
now it correctly shows "ALL" when all the values of the filter are selected; do you how to use concatenatex to shows all the selected values of the filter (eg value1, value2)?
Thanks,
Andrea
@arimoldi
in that case, use the solution provided by @Daniel29195
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks,
I tried but in this way I can see all the values without the "ALL" when all the values are selected:
I solved in this way:
use this measure :
measure =
var rows_count = countrows (all(table_name[field_1]))
var filtered_rows_count = countrows( values(table_name[field_1]))
return
switch(
true(),
if rows_count = filtered_rows_count , "ALL",
concatenateX ( values(table_name[field_1]) , values(table_name[field_1]) , unichar(10))
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
90 | |
86 | |
77 | |
49 |
User | Count |
---|---|
164 | |
149 | |
101 | |
73 | |
56 |