Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX for a tooltip visual

Hello, I have a horizontal bar chart displaying the number of story points completed by area. I want to create a tooltip that includes a pie chart allowing the user to get a visual representation o...
  • Anonymous's avatar
    Anonymous
    6 years ago

    I got this one figured out!

    I created these 3 measures:

     

    Total = CALCULATE( SUM ( 'Sheet1'[StoryPoints] ) , ALL ( 'Sheet1'[AreaLevel] ) )
    Selected = CALCULATE(SUM ( 'Sheet1'[StoryPoints] ) , ALLSELECTED ( 'Sheet1'[AreaLevel] ) )
    NotSelected = CALCULATE( [Total] - [Selected] )
     
    Then, I put the Selected and NotSelected measures in the pie chart Values. Voila! I still have a little formatting to do, but this is working great!
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
6 years ago

Hey Anonymous ,

 

please upload the pbix with sample data to onedrive or dropbox and share the link.

 

Regards,

Tom

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I got this one figured out!

I created these 3 measures:

 

Total = CALCULATE( SUM ( 'Sheet1'[StoryPoints] ) , ALL ( 'Sheet1'[AreaLevel] ) )
Selected = CALCULATE(SUM ( 'Sheet1'[StoryPoints] ) , ALLSELECTED ( 'Sheet1'[AreaLevel] ) )
NotSelected = CALCULATE( [Total] - [Selected] )
 
Then, I put the Selected and NotSelected measures in the pie chart Values. Voila! I still have a little formatting to do, but this is working great!