Returning data in tooltip based on category

[analyticspbi87]

Pretty new to creating dashboards and currently trying to link commentary from another table in a clustered bar chart.

However, I am unable to pull the proper comment.

The current data I have looks like the following:

Category	Sales	Year
A	200	2021
B	300	2021
C	100	2021
D	400	2021
E	200	2021
F	350	2021
A	200	2022
B	300	2022
C	100	2022
D	400	2022
E	200	2022
F	350	2022

And I have a secondary table with comments for a few categories

Category	Comment
B	High due to
E	Low due to
D	xyz

Just wondering the best way to add the comment as a tooltip. The only way I found so far is to adding it as a first comment.

Not sure 

Thanks!

[amitchandak · Accepted solution]

@analyticspbi87 , make syre category is common dimension

Then you can have meausre like

concatenatex(table[category], (categorty], ", ") and use that in tooltip

Or use tooltip page

Power BI Tooltip Page: How to pass selective values to the tooltip page: https://www.youtube.com/watch?v=lEq7YtkxeLU

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...