Forum Discussion

firasath's avatar
firasath
Regular Visitor
2 years ago
Solved

Figure Out How To Filter

Hi,   I have Heacount data in a table where in the column header different Line-of-Business (LOB) are listed and in rows their month wise headcount data is updated as displayed in below table. Here...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi firasath ,
    According to the data you provided, here some steps that I want to share, you can check them if they suitable for your requirement.
    1.Open Power BI Desktop and go to the "Home" tab. Click on "Transform Data" to open Power Query Editor.
    2.Select the LOB columns (LOB-1, LOB-2, etc.), right click and select  "Unpivot Columns"，

    3.Close & Apply, then go to desktop table view and create relationship between Lob and Attribute

    4.Final output

     

    Best regards

    Albert He

     

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

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi firasath ,
According to the data you provided, here some steps that I want to share, you can check them if they suitable for your requirement.
1.Open Power BI Desktop and go to the "Home" tab. Click on "Transform Data" to open Power Query Editor.
2.Select the LOB columns (LOB-1, LOB-2, etc.), right click and select  "Unpivot Columns"，

3.Close & Apply, then go to desktop table view and create relationship between Lob and Attribute

4.Final output

 

Best regards

Albert He

 

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