Tooltip Filtered Results

ljkeefe  I have a workaround solution for your requirement. Instead of tooltip, you can provide drill through to the user to check the list of projects.

Here is my solution:

Output:

Steps:

1. Create a 100% Stacked Bar Chart

2. Bring in Project on Y-Axis and Award to Acceptance on X-Axis

3. Create a measure for getting the Min Value:

Min Award to Acceptance = MIN( ProjectList[Award to Acceptance Duration] )

4. Under "Filter on this visual" for click on 100% Stacked Bar Chart, click on Project

5. Select Filter Type as Top N and choose Bottom and 1 in the field values

6. Bring the measure for Min Value created above and the chart should be filtered down to the minimum value

7. Create a drill through page with a table and pull in your Project column in the table

8. Pull Award to Acceptance and Project column in drill through fields in drill through page

Now, when you do drill through from the chart it should show the desired result.

To use it as a part of your dashboard, just remove all elments (title, data labels) from the chart.

To make it transparent; create this measures for conditional formatting and use it conditional formatting Bar colors:

Conditional Format = "#FFFFFF00"

Now put this chart on top of the card and right click to go to the drillthrough page.

Now, repeate the above steps for all other cards. This way you would be utilizing a single drill through page for all your cards.

Attaching the PBIX file for your reference. Hope this helps.