Just getting started - Colums

[Mattw112]

Sorry I know this will be basic, just getting started.

So I have been able to connect to my data and then put it on a page and create charts.

But having a hard time figuring out how to get it to display as expected.

Let's say you want a chart of Reqs by customer.

Some Reqs can be Open and some can be Closed.

So I want two bars for each Customer.

One bar shows the total of the Open and right next to it a total of the Closed.

So across the bottom I would have multiple customers, each with two bars, one showing total open Reqs and one showing total closed Reqs.

Right now I get 1 bar for each customer with # of reqs, I can do a filter for open or closed, but not sure how I get both.

I've tried dragging the req status column to the Axis area to get multiple axis items.. but hasn't worked.

Thanks,

Terry

[amitchandak]

Refer to my blog which deals with such two dates. Here Opened is Hire, Closed is termination and Open(not closed) is current

HR-Analytics-Active-Employee-Hire-and-Termination-trend

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Mattw112]

Hi I checked out your blog and it was a bit advanced for my level right now.  The other suggestion of adding that to the legand worked some how.  

Thanks,

Terry

[PaulDBrown · Accepted solution]

@Mattw112 

We would need to see the structure of your table(s) to be able to provide adequate help.

However, and hazarding a guess here, if you have a column for open/closed, try dragging that to the legend bucket in the formatting pane of the clustered column visual