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.
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?
Solved! Go to Solution.
@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".
@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".
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 |
---|---|
107 | |
93 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |