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.
Hello,
I have the following table and i am trying to have a card visualization which displays all the text messages associated with a barcode when it is selected, otherwise, it should display "More than one barcode selected". Any help is much appreciated!
Barcode | Text message | Value |
3998 | closed line | 215 |
4050 | open and processing | 189 |
4050 | pending approval | 214 |
4060 | suspended | 158 |
4139 | open and awaiting | 54 |
4145 | open and awaiting | 14 |
4149 | open and awaiting | 548 |
4157 | open and awaiting | 21 |
4160 | pending approval | 54 |
4160 | pending approval | 158 |
4164 | pending approval | 514 |
4166 | pending approval | 155 |
4187 | suspended | 187 |
4187 | closed line | 885 |
4187 | open and processing | 584 |
4187 | closed line | 879 |
4248 | open and processing | 931 |
4314 | closed line | 157 |
4474 | open and processing | 158 |
4481 | open and processing | 145 |
4487 | pending approval | 789 |
4495 | suspended | 652 |
4685 | open and awaiting | 365 |
4688 | open and processing | 144 |
4691 | pending approval | 15 |
4813 | suspended | 145 |
4832 | open and awaiting | 84 |
4997 | open and processing | 641 |
Here is the measure that i am currently using:
Barcode Selected Measure =
IF (
CALCULATE (
HASONEVALUE ( 'My Table'[Text message] ),
ALLSELECTED ( 'My Table' )
)
= TRUE (),
SELECTEDVALUE ( 'My Table'[Text message] ),
"More than one barcode selected"
)
Expected results:
1. when the barcode 3998 is selected from the table visualization, the card visualization displays the text: "closed line". This part is already working.
2. when the barcode 4050 is selected from the table visualization, the card visualization should display the text: "open and processing, pending approval". So, it should join all the text messages associated with that barcode. This part is not working. It currently shows "More than one barcode selected" which is wrong.
3. when more than one barcode is selected from the table visualization (i use ctrl+ to select multiple lines from the table), the card visualization displays the text: "More than one barcode selected". This part is already working.
Solved! Go to Solution.
@Anonymous,
Try this measure:
Barcode Selected Measure =
IF (
NOT HASONEVALUE ( 'My Table'[Barcode] ), "More than one barcode selected",
CONCATENATEX ( 'My Table', 'My Table'[Text message], ", " )
)
-----
-----
Proud to be a Super User!
@Anonymous,
Try this measure:
Barcode Selected Measure =
IF (
NOT HASONEVALUE ( 'My Table'[Barcode] ), "More than one barcode selected",
CONCATENATEX ( 'My Table', 'My Table'[Text message], ", " )
)
-----
-----
Proud to be a Super User!
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
189 | |
96 | |
67 | |
63 | |
53 |