Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
Proud to be a Super User!
Paul on Linkedin.
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
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
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
Proud to be a Super User!
Paul on Linkedin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
49 |
User | Count |
---|---|
144 | |
109 | |
108 | |
87 | |
61 |