Forum Discussion
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:
| Name | Truck | Ship Date | ETA Date |
| Jim | aaa | 28-Sep | 5-Oct |
| Tom | asd | 4-Sep | 8-Sep |
| Laura | xzsxc | 1-Sep | 2-Sep |
| Jim | asda | 10-Oct | 20-Oct |
| Jim | qasd | 10-Oct | 20-Oct |
| Tom | ifgh | 26-Sep | 20-Oct |
| Tom | xcvsd | 23-Sep | 20-Oct |
| Tom | qwev | 1-Sep | 2-Sep |
| Laura | jyed | 20-Sep | 20-Oct |
| Laura | dsafg | 10-Oct | 20-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
1 Reply
- amitchandak
Super User
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.