Forum Discussion
Returning data in tooltip based on category
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!
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-solution-8e3eccb41bda
1 Reply
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-solution-8e3eccb41bda