How to use 2 slicers or condition to display bubbles on Maps

[peerasit_ary]

Here is my data:

Project	Latitude	Longtitude	Type	Price
Project A	13.914159789323909	100.69400125670711	Condo	4,990,000
Project B	13.902449675768354	100.69371035405537	Condo	5,490,000
Project C	13.88199821733605	100.69399460182022	SingleHouse	7,990,000
Project D	13.908562760435542	100.69811584032662	TownHome	10,000,000
Project E	13.950803439104265	100.58534867128547	SingleHouse	13,800,000

I would like to use 2 slicer (1st is Price Between (User prefer between) / 2nd is Checkbox Type) like this

Expect result is Latitude and Longtitude to use with Maps like this

Please advise the solution please.

(The maps is mock up filters)

[Anonymous · Accepted solution]

Hi @peerasit_ary ,

Based on my testing, please try the following methods again:

1.Create the simple tables.

2.Drag the price field into the slicer and drag the type field into the another slicer visual.

3.Create the new measure to filter the two slicers selected value.

two slicers condition = 
var min_price = MIN('Table price'[ Price ])
var max_price = MAX('Table price'[ Price ])
var typ_ = SELECTEDVALUE('Table type'[Type])
var pric_ = SELECTEDVALUE('Table'[ Price ])
var type_ = SELECTEDVALUE('Table'[Type])
RETURN
IF((pric_ >= min_price && pric_ <= max_price) || type_ = typ_, 1, 0)

4.Drag the measure into the Map visualFilters pane and set the show items is 1.

5.The result is shown below.

Best Regards,

Wisodm Wu

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