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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Afreniere
New Member

Combine filters so they show as one unit on x-axis

Hello! I'm relatively new to Power BI and I'm teaching myself as I go. I'm running into an issue that I can't youtube tutorial myself out of. 

I'm working on a report that tracks print jobs at my organization, and I'm trying to break it down by department, so we can see how many print jobs each department has per month, per year, etc...

My data source is a master log of all print jobs broken down by printer, and what I am trying to do is select all the printers for a specific department (say, Accounting) and then display that as a graph that shows how many the Accounting department has done over a span of time. To achieve this I added my printers and time as my x-axis, and filtered the printers to only display the accounting specific printers. What happened though is that the x-axis is now broken down into 3 sections, one for each printer, as opposed to giving me the combined total of my filter. 
Acct printer screenshot.png
I have tried to add those specific printers as a group, but they still display the same way. I've looked at some DAX expressions here, and none have quite seemed to do what I want to do. 

What I would like for the x-axis to look like is just all of the Accounting printers totaled together, so the graph is tracking total print jobs over time, but just showing the totals of the Accoutning department as opposed to each individual printer. 

Any help would be appreciated!


 

1 ACCEPTED SOLUTION
lukiz84
Memorable Member
Memorable Member

just don't put the printers on the x-axis. you can filter anyway (filter pane or slicers)

View solution in original post

3 REPLIES 3
lukiz84
Memorable Member
Memorable Member

just don't put the printers on the x-axis. you can filter anyway (filter pane or slicers)

It's so simple I can't believe I didn't think of it! Thank you so much! Here I was trying to figure out some overly complicated formula when I could have just selected a few fields.

you will have lots of those moments, that's powerbi 😄

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.