Let's say my dataset has few columns - Product, Sales & User Comments etc
I have created a bar chart product vs sales.
Now, if I select any bar, I should be able to see random sample comments about that product in a separate box.
Pretty new to powerbi, have searched for some time, unable to find any solution. Thanks in advance :)
then you can try this to display the first 3 comments.
MEASURE =
IF (
HASONEVALUE ( 'Table'[ProductName] ),
CONCATENATEX (
FILTER ( 'Table', 'Table'[random] <= 2 ),
'Table'[Commnets],
","
)
)