Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Tooltip Report Show Only Flagged Items

I have a table that shows Users and then counts that number of flags for specific items.  I created a Tooltip Page to show further detail.  When I hover over any column though, instead of only showing the flagged details it shows all detail for that user.  So for example,  I have the below data:

 

NameTruckShip DateETA Date
Jimaaa28-Sep5-Oct
Tomasd4-Sep8-Sep
Lauraxzsxc1-Sep2-Sep
Jimasda10-Oct20-Oct
Jimqasd10-Oct20-Oct
Tomifgh26-Sep20-Oct
Tomxcvsd23-Sep20-Oct
Tomqwev1-Sep2-Sep
Laurajyed20-Sep20-Oct
Lauradsafg10-Oct20-Oct

I put it into Power BI and added two columns that flag anything is before today (only column for Ship and one for ETA).  I then created a table to sum all of these flags. 

I then created a report tooltip page to show the name and truck.  What I want is when you hover over "JIM"/  LateShipFlag for it to only show Jim's that are lateshipping, but it shows all of Jims. 

 

Here is a copy of the PBIX

TestPBIX 

 

1 Reply

  • Anonymous , seems like you created two measures. Create a column that has the value LastShip and Late ETA, and if you use that as a column in the matrix, it should filter.