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

[daechir7]

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

[Anonymous]

Hi @daechir7 ,

I think @Uzi2019 's reply is helpful. In the meantime, I am here to talk about my thinking. 

Maybe you can use Card visual to achieve your goals, I created a sample data for you:

Sample data:

1.Add new measures.

Description =
IF (
    ISFILTERED ( 'Table'[Product Name] ),
    SELECTEDVALUE ( 'Table'[Product Description] ),
    "Please selected Product Name"
)

samlpe comments = 
VAR _rank =
    RANKX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Product Name] = SELECTEDVALUE ( 'Table'[Product Name] )
        ),
        CALCULATE ( MAX ( 'Table'[SL.No] ) ),
        ,
        DESC
    )
RETURN
    IF (
        ISFILTERED ( 'Table'[Product Name] ),
        CALCULATE (
            CONCATENATEX ( 'Table', 'Table'[User Feedback], " / " ),
            FILTER ( 'Table', _rank <= 3 )
        ),
        "Please selected Product Name"
    )

2.Put two measures in the card.

 Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[daechir7]

Hi @Anonymous , This is pretty close and exactly how I needed this, there's a slight change in the dataset now 😞 I would need at least 3 comments to show up which are in a single row, separated by a pipe '|' Adding an updated screenshot - ibb.co/ctxHkbX So, if i select the product, it must show the first 3 comments separated by pipe. Sorry, the data I am working with, the layout got changed 😞 

So, store column isn't there anymore. One row for one product and comments are separated by pipe '|'. First 3 comments will work. 

I truly appreciate your help and apolgies for the inconvenience. 

[Anonymous · Accepted solution]

Hi @daechir7 ,
sample data:

You can modify your measure:

top3 comments = 
VAR _userfeedback = SELECTEDVALUE( 'Table'[User Feedback] )
VAR _rank =
    RANKX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Product Name] = SELECTEDVALUE ( 'Table'[Product Name] )
        ),
        CALCULATE ( MAX ( 'Table'[SL.No] ) ),
        ,
        ASC
    )
VAR _top3 = IF(_rank<=3,_userfeedback,BLANK())
RETURN
_top3

sample comments = 
    IF (
        ISFILTERED ( 'Table'[Product Name] ),
        CONCATENATEX ( 'Table', [top3 comments], " | " )
        ,
        "Please selected Product Name")

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[daechir]

This works perfectly, thank you so much 🙂

[Uzi2019]

Hi @daechir7 

You can use tooltip feature on product vs sales chart. follow these video for better understnding.

https://www.youtube.com/watch?v=k0cwSYNXhkI

https://www.youtube.com/watch?v=a5HlBrBygVE

https://www.youtube.com/watch?v=rxtuYqMZsZg

I hope this may help to set tooltip with top 3 comments by sales.

add table in your tooltip page and comments and other fileds you want

just use visual filter > top n >3 > put values > sales 

I hope i answered your question!

[daechir7]

Hi @Uzi2019 , thanks for your response. However, I am specifically looking to show up the comments in a text box instead of the tooltip. The Default text must say as it is in the output boxes and should show the description in one box and comments in the other box when a bar is selected. 

But if I don't find a solution to my expectation, then I will utilize the one you have shared. 🙂

[Uzi2019]

 @daechir7 

You can add simple table add comments and seperate table add description. when you select somthing on chart it auto filters the tables values( comments and description).

other wise there is nothing much I can suggest.. 
tooltip is actually a good feature that you can utilized.

I hope i answered your query.

[daechir7]

Thanks @Uzi2019 for another great alternative. I'd still keep it open and see if the exact thing could be done. 🙂