Need help with "Filter by List" Custom visual

[v-dpjain]

Hi Team,

I have two line charts which shows revenue trend for two different set of customers. I have the chart as Date VS Monthly AVG revenue for the customers IDS (TPID)  and have applied the "Filter by List" Custom visual , where a user can input the list of customers(TPID) he want to check the revenue trend for . (see the image below) :

My objective now is to combine this two line charts into a single one, so that a user can easily compare the revenue trends of his chosen customer sets (Seomthing like below). I.e  A single chart to compare revenue trend between 2 or more sets of customer IDS which are been entered by the user in the "Filter by List" Custom visual

This is the table i am using for the visual

[V-lianl-msft]

Hi @v-dpjain ,

You select 2 TPID in the slicer and in one formula you choose min TPID and another one you choose the second

TPID

Try to create two measures like below:

TPID1 =
var _min = MINX('Table','Table'[TPID])
return
calculate([Measure], 'Table'[TPID]=_min)

TPID2 =
var _max = MAXX('Table','Table'[TPID])
return
calculate([Measure], 'Table'[TPID]=_max)

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