Forum Discussion
can't add second value to bar graph
You need something for your axis. So either your fiscal year as your axis or something else.
Community ChampionCouple things to check, make sure your columns are not text for some reason. Are both counts measures or are they columns with a count or sum aggregation? Do you have a field in the Legend already? Sample data would help. I can create a bar chart with a common axis and drag two or even three values into it, in my case 2 columns and a measure. Even if I drag a text column to values it automatically changes to "Count of column". Very odd behavior you are seeing. There's reason but need more info to know what is going on. Even if I have something in the Legend if I drag another column into Value, it replaces the current column there and doesn't move it to Tooltips. What version of Power BI Desktop are you on?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Both values are whole numbers. They aren't counts of a larger data set, just a total in a chart with other totals. I can add both values to a blank graph, but then I can't add fiscal year to be the legend. It wants to sum all the numbers.
The data looks like this:
Prior FY Count Current FY Count Pct
2015-2016 840 585 69.6%
2016-2017 908 562 61.9%
2017-2018 884 632 71.5%
2018-2019 947 33 3.5% (this one is FY to date)
- Greg_Deckler
You need something for your axis. So either your fiscal year as your axis or something else.
Yes, that did it. I added the fiscal year as the axis first and then it let me add the two variables as values.