Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Mattw112
Helper I
Helper I

Just getting started - Colums

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

1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

@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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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
Community Champion
Community Champion

@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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!