Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
7 years ago

Visual filter using TOP N

Hi guys,   Need advice how to use TOP N feature in Visual level filters.  If lets say I have this kind of data : Customer Group    Customer Sales Amount Group A A001 12 Group A A002...
Tutorial Requests
Gordonlilj's avatar
Gordonlilj
Solution Sage
7 years ago

Hi,

 

You could try and create a calculated column that combines group name and customer like this for example.

 

CalculatedColumn = 'Table'[Customer Group] & " " & 'Table'[Customer]

Then use the new column just as an extra visual filter and not in the actual visualisation

 

 

Doing this gives me the correct result based on the data and example you provided