Compare data in time with different segmenters

[Syndicate_Admin]

Hello and greetings to all, really one learns a lot here and I thank you in advance for any help to this problem of mine. I have a table with 4 columns

TIME - PERIOD - WAREHOUSE - HOURS

In year, they are from 2019 to 2023

In period, the months of the year

In warehouse, there are 114 warehouses

In hours, they are the total hours that I work each warehouse.

I want to make a line chart showing the total hours per month, but I must put 3 warehouse data segmenters. The idea is that in each segmenter one places a different warehouse and so the graph shows me three lines with the total hours behind the months of each warehouse and thus be able to compare them.

Thank you very much in advance

[v-jianboli-msft]

Hi @Syndicate_Admin ,

You mentioned that you have 114 warehouses, 3 segmenters. What do these three segmenters look like? What does "in each segmenter one places a different warehouse" mean? Can you explain it in detail?

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.