custom tooltip based selected cell

Hi,

Thanks for the solution rajendraongole1  and bhanu_gautam  offered, and i want to offer some more information for user to refer to.

hello NadeemAhamed , based on your description, you can refer to the following sample.

Sample data 

And i create two measures.

Color =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Table'[Type] ) = "A", "red",
    SELECTEDVALUE ( 'Table'[Type] ) = "B", "blue",
    SELECTEDVALUE ( 'Table'[Type] ) = "C", "green"
)

Tooltip =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Table'[Type] ) = "A", "it's A",
    SELECTEDVALUE ( 'Table'[Type] ) = "B", "it's B"
)

Then for the first requirement, can create a table visual, then click the conditional formatting, and select background color.

Then put the color measure to it.

Output 

And you can refer to the following link to know about the conditional formatting.

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

powerbi - How to conditionally format a row of a table in Power BI DAX - Stack Overflow

For the second requirement, add a new page and allow it  as tooltip.

Then set it actual size as tooltip.

Then add a card visual and put the tooltip measure to the visual.

The return the page that display the table visual, then open tooltip, and select report page, and select the page which set as tooltip.

Output

And you can refer to the following link to know more about the custom tooltip.

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

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.