Report Tooltip displaying extra info connected to pivoted data.

[Jason_Jones_au]

hi there,

Complete PowerBI newbie, with a dataset (from SQL) with rows that contain date, an identifier (tagname) , tag value for that tagname for that date... and the more human readable tag description for those tagnames. For the report I pivoted so that we have column one is the date column followed by each of the tag descriptions (now displayed as columns) . This way operators have a row for each date for the important information.  To pivot, I had to remove the tagname column. Now from time to time the underlying tagname may change (in the SQL query that feeds the dataset). To make troubleshooting easier and because most operators know what the tagname means I thought, hey,  you hover over the particular value for a particular tag description column and Date row .. and the cool Report tooltip will show you the raw tagname that was used. The problem is the dataset no longer has the tagname column and I can't make a relation in the data model between my pivoted dataset and another table (that contains Tagname and Tag description) because I dont know how to relate based on the name of a column (each column is a tag, not a single column that contains a list of tags).  I see people unpivoting to then relate , guys in cubes  melting my brain with all the cool things that can be done.. but as yet no obvious way to achieve this .... help 

[lbendlin]

None of this will help you if you use a visual that doesn't support tooltips.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Anonymous]

Hi @Jason_Jones_au,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Jason_Jones_au]

Data from a SQL query (dummy data)

Tag Name	Tag description	Date	Value
T1	temperature - celcius	1970/01/01	30.0
T2	pressure - Kpa	1970/01/01	100.0
T3	Reservoir % full	1970/01/01	90.0
T1	temperature - celcius	1970/01/02	29.0
T2	pressure - Kpa	1970/01/02	101.0
T3	Reservoir % full	1970/01/02	91.0
T1	temperature - celcius	1970/01/03	28.1
T2	pressure - Kpa	1970/01/03	99.0
T3	Reservoir % full	1970/01/03	92.0
T1	temperature - celcius	1970/01/04	28.7
T2	pressure - Kpa	1970/01/04	101.0
T3	Reservoir % full	1970/01/04	93.0

pivoted to display 

	temperature - celcius	pressure - Kpa	Reservoir % full
1970/01/01	30.0	100.0	90.0
1970/01/02	29.0	101.0	91.0
1970/01/03	28.1	99.0	92.0
1970/01/04	28.7	101.0	93.0

And the requirement is to display the actual Tag Name when hovering over the value cell. This way they can see that the temperature data uses T1 , which they can then query in a different system.  

Hope this helps explain the scenario

[Anonymous · Accepted solution]

Hi @Jason_Jones_au,

You can refer to the following steps to achieve your requirements.
1. Write a measure formula to show the tag name based on current filter effects.

TagName = 
CALCULATE (
    CONCATENATEX ( VALUES ( 'Table'[Tag Name] ), [Tag Name], "," ),
    ALLSELECTED ( 'Table' ),
    VALUES ( 'Table'[Date] ),
    VALUES ( 'Table'[Tag description] )
)

2. Create a custom report tooltip page with card visual and above measure expressions.

Create report tooltip pages in Power BI - Power BI | Microsoft Learn

3. Turn on the matrix tooltip option on the 'format' -> 'General' tab, choose the custom report tooltip page as tooltip.

Regards,

Xiaoxin Sheng

[lbendlin]

@Anonymous thank you for this, I was always wondering why I couldn't use tooltips in matrix visuals. Turns out I wasn't looking in the right spot.