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.
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.
I have looked at similar values, however they are a bit unrelated:
The model/data looks something like this:
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 🙂
Solved! Go to Solution.
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
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:
This will add additional fields to your tooltip but keeping the ones you already use.
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!!).
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!