powerbipowerbi-desktoppowerbi-custom-visuals

On selection of a product from a product vs sales bar chart, I want to see top 3 user comments about that particular product


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 :)

Dataset example

Expected Output


Solution

  • then you can try this to display the first 3 comments.

    MEASURE =
    IF (
        HASONEVALUE ( 'Table'[ProductName] ),
        CONCATENATEX (
            FILTER ( 'Table', 'Table'[random] <= 2 ),
            'Table'[Commnets],
            ","
        )
    )
    

    enter image description here