Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

tool tip

hi

i have a bargraph where the tool tips display all the data related to all the bars

now what i want is i want my tool tip to display data realated to that particular bar only

how can i do that

 

current output

Need Help
Show and Tell
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    Based on your description, I have created the sample table like this:

    Create a measure and use it in tooltip to show each week's total sales:

    Week total sales =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    FILTER ( ALL ( 'Table' ), 'Table'[Week] IN DISTINCT ( 'Table'[Week] ) )
)

    Attached a sample file in the below, hopes to help you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi Anonymous ,

    Based on your description, I have created the sample table like this:

    Create a measure and use it in tooltip to show each week's total sales:

    Week total sales =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    FILTER ( ALL ( 'Table' ), 'Table'[Week] IN DISTINCT ( 'Table'[Week] ) )
)

    Attached a sample file in the below, hopes to help you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.