I have a summary chart of various values by fiscal year. It has three values per fiscal year for several constuencies (a base count, a new count, and a percentage calculated from the two). I'd like to compare the two counts in a bar chart. When I try to drag the second variable to Value, it instead drops it into Tooltips. I cannot get PowerBi to let me drag it into Value. Both variables are whole numbers. What is wrong with my data?
Solved! Go to Solution.
Couple 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)
Stacked bar won't work with my data. It looks like this:
Base Count 101
New Count 59
I want to be able to show base count next to the new count in a clustered bar graph. The users of the data want to see the before and after counts for just one year at a time (previous year and current year). I'll have another graph that compares the percentages for multiple years.
Strangely, I got it to work by first trying it as a combined bar and line graph and then clicking on other charts to see if any of them worked better. After going to the ribbon, I then went back to the bar and line, but it left both variables in Value for the bar chart (with nothing for the line chart). I thought I'd try the combined bar graph again to see if it stuck, and it did. I still don't know why it wouldn't let me add the second variable initially. I'd still like help with that, if possible, in case I need to do this again.
Shabnam Watson demos Incremental refresh & Hybrid Tables and Leila Etaati demos Charticulator.
Click here to read more about the April 2022 updates!
Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!