Forum Discussion

SaaM's avatar
SaaM
Icon for Helper II rankHelper II
5 years ago
Solved

Bar chart by category with total

Hi all,   Here a preview of my data:   and I would like to have something like this: How I proceed to get this:   I created one graph with the data athlete and the distance runned ...
Need Help
Show and Tell
Tips and Tricks
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    Create a measure along the lines of:

    Distance to goal = [Goal]-[Distance Run]

    Then create the stacked chart with the [Distance run] and [Distance to goal] measures. Turn on the "Labels" & "Total label" in  the formatting pane, and if you want to sort the visual by Goal, add the goal measure to the Tooltips. And you get this:

     

     I've attached the sample PBIX file

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Create a measure along the lines of:

Distance to goal = [Goal]-[Distance Run]

Then create the stacked chart with the [Distance run] and [Distance to goal] measures. Turn on the "Labels" & "Total label" in  the formatting pane, and if you want to sort the visual by Goal, add the goal measure to the Tooltips. And you get this:

 

 I've attached the sample PBIX file