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!
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey TomMartens , that's so close to what I was thinking. I was thinking DAX would be needed because in my perfect world the pie would show the percentage of, say "Computers" from your screenshot as dark blue and then, the rest of the pie would be grey for all others. The reason for wanting that is because the user is only interested in seeing how much of the total is "Computers" (again, just from your example) versus all other categories. It wouldn't be necessary to see all the slices of all the categories. I also think DAX would be helpful for a title on the tooltip to display the category being hovered over.

 

I have an Excel file with a small set of aggregated data. Can I send that to you? I don't see an option to add an attachment here so I'm including screenshots of the data and two charts. One horizontal bar chart for the Main Chart and a Tooltip Chart for what I'm thinking about. The Tooltip Chart is what you would see if you hovered over "Operations" from the Main chart.

 

 

Thanks for any guidance here!
Adam

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello, just wanted to bump this one. Anyone have any ideas?

Thanks!

  • 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!