Forum Discussion

fibaek's avatar
fibaek
Icon for Helper I rankHelper I
5 years ago

Display dimension in tooltip based on slicer selection

Hello, I have a report based on a live connection to a PBI Dataset. In the report I have a clustered column chart with a tooltip that displays further details. There is a slicer on the page that all...
Need Help
fibaek's avatar
fibaek
Icon for Helper I rankHelper I
5 years ago

Hi Miguel,

Thank you for your reply – your input is highly appreciated!

I have been playing around with you suggested solution, and it is definitely going in the right direction. However my tooltip is a table (screenshot below) with com calculated measures. The months in the screenshot are the ones that should ideally be region/bu/sbu. When I try to create a table it seems like I get all records in the selected dimension resulting in a long list. I’ll create a .pbix with some scrambled data tomorrow.

/Sune

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    Hi fibaek,

     

    Looking at the information you are giving you need to the following:

     

     

    • Change your measure to:

     

    Filtering =
VAR selection_value =
    SWITCH (
        TRUE ();
        ISFILTERED ( 'Table'[Region] ); MAXX ( 'Table'; 'Table'[BU] );
        ISFILTERED ( 'Table'[BU] ); MAXX ( 'Table'; 'Table'[SBU] );
        ISFILTERED ( 'Table'[SBU] ); MAXX ( 'Table'; 'Table'[Region] )
    )
RETURN
    IF ( ISINSCOPE ( 'Table'[BU] ); selection_value; "Total" )

     

    Once again order is very import 

    • Create a table visualization for your tooltip with the following setup:
      • BU - Hide column
      • Filter Measure
      • Your measure
    • Create a measure with the following code for condittional formatting:
    Filtering colour =
SWITCH (
    TRUE ();
    ISFILTERED ( 'Table'[Region] ); "#00000000";
    ISFILTERED ( 'Table'[BU] ); "#00000000";
    "White"
)
    • Added this step since I don't know what you want to present in the tooltip when you have no selection so I created this to "hide the tooltip chart"
    • Create a card visualization and format the background and the data label with the filtering colour
    • Place the can with the size and on top of your table visualization

    Result below and in attach PBIX file: