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.
Hi,
I am new to the community, and I really hope you can help me.
I have a column with various organizational units, 15 different units, +8 specific unites per unit and over 1300 people belonging in those specific units.
- ET/UTJ/BMM/TK-TUT/ASSET/T&P/B&J
- ET/UTJ/BMM/TK-TUT/ASSET/T&P/ESNR/BATH
- ET/UTJ/BMM/TK-TUT/ASSET/T&P/WINT
- ET/UTJ/BMM/TK-TUT/ASSET/T&P/E&O/D&WO
The only thing I then want to remain is T&P, so that everything else goes. I already tried to filter the column for all T&P and then extract everything before and after, so that only T&P remains. It works fine, but T&P is only one of 15+ org units and when I do this it seems like I lose all other data in the table except for the one belonging to T&P.
Hi @Anonymous ,
If you filter data with T&P it's obvious that other units will not show up, could you please clarify the need.
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.