cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joshua1990
Super User
Super User

Tooltip per Column/ Measure

Hello everyone!

I have a matrix with severall columns/ measures.

I also have a dictionary for most of the measures.

Is there any chance to display the description as a tooltip fo every column in the matrix?

The dictionary is developed as a hudge excel spreadsheet.

1 ACCEPTED SOLUTION
v-xicai
Community Support
Community Support

Hi @joshua1990 ,

 

You may create a Tooltip page for the Matrix visual, put [Description] and the specific measures ore columns into a visual of Tooltip page , then go to main report page, select the Format section and choose the Tooltip card you created , for reference: Create tooltips based on report pages in Power BI Desktop. Based on your data, I have created a tooltip for the Matrix visual. You may download the pbix file from here.

 

When you hover the fields of the Matrix , the Tooltip will appear.

160.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

View solution in original post

9 REPLIES 9
v-xicai
Community Support
Community Support

Hi @joshua1990 ,

 

You may create a Tooltip page for the Matrix visual, put [Description] and the specific measures ore columns into a visual of Tooltip page , then go to main report page, select the Format section and choose the Tooltip card you created , for reference: Create tooltips based on report pages in Power BI Desktop. Based on your data, I have created a tooltip for the Matrix visual. You may download the pbix file from here.

 

When you hover the fields of the Matrix , the Tooltip will appear.

160.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

@joshua1990 Hi,

Were you able to find the solution for your requirement.

Even I have the same requirement from client and looking for the solution.

 

Thanks,

AA

@v-xicai Thank you so much! This is what I am looking for!

But I need a filter in the tooltip.

For now I get the same tooltip regardless of Sales or Measure.

But since Sales and Measure are representing different data there is for each a different Description.

Is there any chance to get just the corresponding description for the "selected" measure?

So if I go over Sales I just get the Description for Sales.

Hi @joshua1990 ,

 

Generally, the filter interaction will work when there are linked relationships between these tables and fields. While there is no and unsupported to create linked relationship between the selected measure and the [Measure Name] in Tooltip. So your demand may not be achieved currently. The Tooltip which shows all of the measure name is a kind of alternative method for you now.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

pranit828
Community Champion
Community Champion

Hi @joshua1990 ,

 

You will need to create a page tooltip.

Chekc the below detailed video.

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

 

This will serve the exact purpose you are looking for.

 





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

Please find attached an example file:

https://workupload.com/file/7KMBmbJLpwW

simrantuli
Continued Contributor
Continued Contributor

Hi @joshua1990,

 

Would be great if you could provide the sample data. 

 

Best Regards

Simran Tuli

Fowmy
Super User
Super User

Hi @joshua1990 

As long as you have your data available in your data model, it is possible. Provide more details to solve your issue.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

@Fowmy Thank you for your support!

Basicly it is pretty simple.

For instance, I have the measure [Sales] and then I have an Excel spreadsheet in the Data Model that shows/ contains per Measure a description. 
It is a table with MeasuresName - Description.

now I would like to add this description to the matrix and the column [Sales]. In the next column I have the next measure.

So, I want to display in the tooltip for every measure in my Matrix the corresponding description of the Excel Sheet.

Do you need further information?

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors