I actually don't know how to word this topic, but I have a set of data, and I'm trying to create a bar chart so that it has actual vs plan numbers.
My data is structured in such a way that I have a "Year" column, a "value" column, and a "type" column. The type column has 2 values: "Actual" and "Planned".
If I create a simple bar chart in powerBI and put the "Year" on the axis, filter for "type = Actual", and put the "value" in the value field, then I get a bar chart with 2015,2016, and 2017 with actual values. However, I want to add one more bar chart to the far right that has 2017 plan numbers.
how would I go about adding the plan numbers in?
My data is structured in such a way that I have a "Year" column, a "value" column, and a "type" column. The type column has 2 values: "Actual" and "Planned".
If I create a simple bar chart in powerBI and put the "Year" on the axis, filter for "type = Actual", and put the "value" in the value field, then I get a bar chart with 2015,2016, and 2017 with actual values. However, I want to add one more bar chart to the far right that has 2017 plan numbers.
how would I go about adding the plan numbers in?