filtered bar charts

[#1]

Hi,

I have two questions about how to show filtered versions of expressions in bar charts and text boxes.

For a text box, assume I have

Budget Spend - Large Vendor and Small Vendor
Actual Spend - Large Vendor and Small Vendor

I want to show just the large vendor budget spend. Is there a way to filter the categories in the expression?

2. Second question is how to filter both the dimension and the expression. I have attached a QV with loaded data. I want a bar chart that looks like the bar charts in the attached slide. Any advice is really appreciated!

[rustyfishbones · Accepted solution]

Hi

You could try the follow for part 1, assuming the Column(Dimension) is called Vendor

SUM({$<Vendor ={'Large Vendor'}>} [Budget Spend])

SUM({$<Vendor ={'Small Vendor'}>} [Budget Spend])

SUM({$<Vendor ={'Large Vendor'}>} [Actual Spend])

SUM({$<Vendor ={'Small Vendor'}>} [Actual Spend])

Let me know if this works

[#3]

works perfectly! let me know if you have thoughts on part 2. thanks!

[rustyfishbones]

Can you attach the .xlsx and so I can reload the Data

[#5]

attached!

[rustyfishbones]

Here is my take on it,

look at the Expressions in the Charts and Text Objects and let me know if that helps

[rustyfishbones]

Here is a video that may also help

http://www.youtube.com/watch?v=RrTqtFy3i0g

[#8]

looks great - i applied similar logic to my data! one question though - is it possible to wrap text on the labels?

[rustyfishbones]

Not sure what you mean!

Do you want to wrap the text within a Text Object or in the Chart Labels

[#10]

In the chart labels. The chart I sent you was illustrative. One of the other expenses is "Information Technology" - I want to either relabel it IT or wrap text in the chart so Information is on one line and Technology is on the second.

One other thing - is there a way to show % change between the budget and actual bars for each expense? For instanceshow the % change between Army construction budget and Army construction actual as one data label, and do the other two expenses under army similarly.

thank you!!