See the Duplicate Values in the Tooltip

[natasha_antosha]

Hi,

I have a table with ITEM and UNIT OF MEASURMENT. I have a big list of ITEMs, but there are a lot of repetitions, what I mean Is that there are a lot of ITEMS with the same number, but different units of measurement. For example, UNIT no 12345 can be in EA or PL UNIT OF MEASURMENT. And I want to create a tooltip so that when I hover over the item and unit of measurement (for example, EA) it will show me all other units of measurement (for example, PL) that exist for this ITEM. How do I do it? 

[123abc]

To create a tooltip that displays all other units of measurement for the same item when you hover over an item in Power BI, you can use DAX and a Tooltip page in your report. Here's a step-by-step guide on how to achieve this:

Step 1: Create a Tooltip Page

1. In Power BI Desktop, create a new page in your report by clicking on the "New Page" button in the Pages pane.

2. Rename the new page to something like "Tooltip."

Step 2: Create a Tooltip Measure

1. In your data model, create a new calculated measure. This measure will concatenate all the units of measurement for the same item.

Tooltip Text = VAR CurrentItem = SELECTEDVALUE(YourTableName[ITEM]) VAR AllUnits = CONCATENATEX( FILTER(YourTableName, YourTableName[ITEM] = CurrentItem), YourTableName[Unit of Measurement], ", " ) RETURN IF(LEN(AllUnits) > 0, "Other Units of Measurement: " & AllUnits, "No other units")

1. Replace YourTableName with the actual name of your table.

2. Set the data type of the "Tooltip Text" measure to "Text."

Step 3: Configure the Tooltip Page

1. On the "Tooltip" page, add a text box visual.

2. In the Values field well of the text box, drag and drop the "Tooltip Text" measure you created in the previous step.

Step 4: Configure the Tooltip for the Main Page

1. Go back to your main report page where you want the tooltip to appear.

2. Select the visual (e.g., a table or a chart) to which you want to apply the tooltip.

3. In the Visualizations pane, go to the "Format" section.

4. Expand the "Tooltip" card.

5. Toggle on the "Tooltip" switch.

6. Set the "Tooltip type" to "Report page" and select the "Tooltip" page you created earlier.

Step 5: Test the Tooltip

1. Save and publish your report.

2. When you hover over an item in your main report page, the tooltip will display the concatenated list of other units of measurement for that item from the "Tooltip Text" measure.

The tooltip will dynamically change based on the item you hover over, showing all other units of measurement associated with that item. If there are no other units, it will display "No other units."