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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.