Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
joshua1990
Post Prodigy
Post Prodigy

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

10 REPLIES 10
erok
Regular Visitor

What I'm looking for is a column format option that lets you display a Tip for the column.  For example, the column name is "Profit", Column Tip is "Sales - Costs = Profit".  When I hover over an "i" in the corner of the column name box, the Column Tip would display.  Or, could we have the Description of the field show like it does when you hover over it in the Data Visual Tool?

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors