cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mkusf
Frequent Visitor

need help editing tooltip (title, measure information, column information)

Hello! I have two visualizations where I wanted to modify some information in the tooltips. I know about report tooltip pages, however I am unsure how I can use them to customize information in tooltips in the graphs below.

 

For the line chart I wanted the graph tooltip to show Year and full month name. I have a full month name column however since the X-axis needs to have 3 letter month, the tooltip defaults to Axis value. Furthermore, I also have a Count Values column, and I was hoping that I can concatenate the Count Values to % Value information.

 

Screenshot%202021-12-27%20080357

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Next I have a stacked bar percent chart, and here I wanted to say Year, Month for the title of the First row. And similar to the line chart, say the full month name.

 

Screenshot%202021-12-27%20080556

 

 

 

 

 

 

I have looked at similar values, however they are a bit unrelated:

https://community.powerbi.com/t5/Desktop/Edit-Tooltip-First-Last-Middle/m-p/297078#M131088

 

The model/data looks something like this:

 

Screenshot%202021-12-27%20081339

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

data in .csv format:

Count Values,Date,Gender
33,9/27/2014,F
54,10/11/2014,M
45,11/27/2014,F
87,12/15/2014,M
78,12/30/2014,F
12,1/19/2014,M
78,1/21/2014,F
15,1/25/2014,M
63,1/29/2014,M
24,2/6/2014,M
4,1/27/2014,M
56,2/11/2014,M
4,2/27/2014,F
4,2/15/2014,M
25,3/30/2014,F
58,4/27/2014,M
35,5/11/2014,F
78,5/27/2014,M
12,6/15/2014,F
23,6/30/2014,M
23,7/15/2014,F
69,7/30/2014,M
23,7/15/2014,F
23,8/30/2014,F
23,1/19/2014,F
54,1/21/2014,F
23,1/25/2014,F
8,1/29/2014,F
7,2/6/2014,F
98,1/19/2014,F
1,1/21/2014,F
4,1/25/2014,F
9,1/29/2014,F
7,2/6/2014,F
7,1/19/2014,M
7,1/21/2014,M
97,1/25/2014,M
94,1/29/2014,M
1,2/6/2014,M
1,1/19/2014,M
56,1/21/2014,M
1,1/25/2014,M
89,1/29/2014,M
56,2/6/2014,M

 

Here are all the measures and columns created to make those visuals above:

Created Columns
---------------

ShortMonth = FORMAT(data[Date], "mmm")

MonthNumber = data[Date].[MonthNo]

ShortDay = DAY(data[Date])

ShortYear = YEAR(data[Date])

Month = FORMAT(data[Date], "mmmm", "en-US")


Created Measure
----------------

Sum Value = SUM ( data[Count Values] )

% Value = 
DIVIDE (
    [Sum Value],
    CALCULATE (
        [Sum Value],
        ALLSELECTED (),
        VALUES ( data[ShortYear] ),
        VALUES (  data[ShortMonth] )
    )
)

Created Hiearchy (Custom date for the X axis, Year and 3 Letter Month)
----------------

Date Hiearchy : ShortYear -> ShortMonth

 

Please let me know if I can clarify anything. Thank you in advance 🙂

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @mkusf ,

 

The best option is to create a custom tooltip with the information how you need it:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

7 REPLIES 7
Noorani
Helper II
Helper II

Hi @mkusf,

I think creating a tooltip page will the required information will solve your problem.

Here's a guide to help you: Using report tooltip pages in Power BI - Power BI | Microsoft Docs

mkusf
Frequent Visitor

Thank you @Noorani ! Appreciate your help 🙂

MFelix
Super User
Super User

Hi @mkusf ,

 

The best option is to create a custom tooltip with the information how you need it:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



mkusf
Frequent Visitor

Hi @MFelix, Thank you. I do have some knowledge about that. I was hoping there might be a straightforward way than that since I needed just minor changes to my tooltips. However I will give that a try 🙂

Hi @mkusf ,

 

You can also add the tooltip fields to the bottom of the visualization:

MFelix_0-1640622187947.png

 

This will add additional fields to your tooltip but keeping the ones you already use.

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



mkusf
Frequent Visitor

Unfortunately when I do that with my actual data the tooltip loses some information on longer legend (That was the first thing I did before posting my question here!!). 

@mkusf ,

 

Then you need to make use of the custom tooltip, that allows to have more customized sizes.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors