cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sharmon9000 Regular Visitor
Regular Visitor

Filter Weekly Totals by Company when both weekly totals are returned in 1 row

I was trying to figure out a way to filter by company when the weekly totals are returned on 1 row by week.

 

Example of returned row from database:

| WeekEnding  |   Company1   |  Company2  |
  2019-07-27       2500           3500
  2019-07-20       2200           3350
  2019-07-13       2600           3450

It was easy to combine the totals by week using a measure and SUM to combine both totals. But is it possible to have a filter where the TOTAL will be updated depending on if Company1 or Company2 or Both is selected?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Filter Weekly Totals by Company when both weekly totals are returned in 1 row

@sharmon9000 - When more than one column are essentially the same data, it is best to "Unpivot" the columns. The easiest way to unpivot columns is in Power Query. Click "Edit Queries" to open the Power Query Editor, and then do the following:

1. Select Transform tab.

2. Select "WeekEnding" column.

3. Click the arrow next to"Unpivot Columns". 

4. Click "Unpivot Other Columns".

Unpivot.PNG

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
Nathan Peterson

View solution in original post

1 REPLY 1
Super User
Super User

Re: Filter Weekly Totals by Company when both weekly totals are returned in 1 row

@sharmon9000 - When more than one column are essentially the same data, it is best to "Unpivot" the columns. The easiest way to unpivot columns is in Power Query. Click "Edit Queries" to open the Power Query Editor, and then do the following:

1. Select Transform tab.

2. Select "WeekEnding" column.

3. Click the arrow next to"Unpivot Columns". 

4. Click "Unpivot Other Columns".

Unpivot.PNG

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
Nathan Peterson

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 270 members 2,944 guests
Please welcome our newest community members: