Forum Discussion

Ashwini81's avatar
Ashwini81
Regular Visitor
4 years ago
Solved

Data for Page Level Filter from multiple columns

I have a table which gives information like OS and RAM Size about computers and also Tags associated with that computer.

ComputeNameOSRAMTags
Comp1Windows16GBTeam1, Team2
Comp2Linux8GBTeam2
Comp3MAC16GBTeam1, Team2,Team3
Comp4Windows8GBTeam3, Team1
Comp5MAC8GBTeam2, Team3
Comp6MAC16GBTeam3
Comp7Windows16GBTeam1
Comp8Linux16GBTeam1, Team2, Team3
Comp9MAC16GBTeam1, Team2
Comp10Windows8GBTeam2

In my Power BI report there needs to be a page level filter which will be applied to all the visuals in the page. Eg: The filter should have the following data Team1, Team2, Team 3 and on choosing a particular Tag, the computer information regarding that Team should be shown in the report page.

I split the Tags column using the 'split column' option. Now I am not able to show the Tags from the 3 columns in a fpage level filter and filter the visuals based on the option chosen. 
Any help with this is appreciated.

 

Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    3 years ago

    Hi Ashwini81 ,

     

    I recommand you to use "unpivot columns" to do that.

     

    Add one step to the power query

    = Table.UnpivotOtherColumns(#"Changed Type2", {"ComputeName", "OS", "RAM", "Tags"}, "Attribute", "Value")

     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi,

    Unfortunately I cannot see the attached pbix-file. I think one way to solve this issue is by:
    1. As you said, split the column,

    2. Make a separate table with a column of all the team names
    3. Create a relationship between the two tables
    4. Use the newly created table as filter 

  • Ashwini81's avatar
    Ashwini81
    Regular Visitor
    4 years ago

    I created a new table by taking distinct values from the columns which I got after splitting. This new table had 1 column. However i could not create relationship from this newly created table column to the 3 columns of my original table as only one relation can be active. The filter should be able to filter from all the 3 columns..

    Here is the Power BI Report TagsReport 

     

    • v-chenwuz-msft's avatar
      v-chenwuz-msft
      Community Support
      3 years ago

      Hi Ashwini81 ,

       

      I recommand you to use "unpivot columns" to do that.

       

      Add one step to the power query

      = Table.UnpivotOtherColumns(#"Changed Type2", {"ComputeName", "OS", "RAM", "Tags"}, "Attribute", "Value")

       

      Pbix in the end you can refer.

      Best Regards

      Community Support Team _ chenwu zhu

       

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