Forum Discussion

andykbba's avatar
andykbba
Regular Visitor
2 years ago

Top N Filter

Hi all,

I have some general Australian Bureau of Statistics Data.

Essentially I have the location of a place in Australia  (in one column)

 

 

And 19 other columns which show how many people in Australia work in one particular area of employment.



When i create a treemap it looks overly clustered as it is trying to fit all 19 industries of employments in.

I have a slicer which can be applied to produce the results for each postcode and the industries of employment vary depending on what is most popular in each area.

How do i apply a limitation/filter to only show the top 5 industries of employment in the tree map?

Need Help
Show and Tell

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    In the Query Editor, select the Location column, right click and select "Unpivot Other Columns".  Click on Close and Apply.  Work with this transformed dataset.

    • andykbba's avatar
      andykbba
      Regular Visitor
      2 years ago

      Hi thanks for this suggestion, 

      When I do this it provides me with the following error. 

       






      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        2 years ago

        On unpivoting, entries in the location column are repeating causing the Many to One relationship to fail.  Create a Location Dim Table which should only have all the unique locations.  Create Many to One relationships to this Location dim table.