Get Selected Value Based on Two Slicers

[lxiaoxi]

Hi,

I am trying to figure a way to get selected value based on two slicers. There is no calculation about the value, just return the value itself.

For example:

Product	Drive	Cost	Time
A	I	52	2018-07-16T00:00:00Z
A	L	39	2018-07-31T00:00:00Z
A	E	69	2018-07-29T00:00:00Z
A	I	97	2018-07-28T00:00:00Z
A	I	92	2018-08-07T00:00:00Z
A	I	10	2018-08-06T00:00:00Z
A	I	75	2018-08-05T00:00:00Z
A	L	23	2018-07-23T00:00:00Z
B	I	89	2018-07-25T00:00:00Z
B	E	66	2018-07-28T00:00:00Z
B	L	38	2018-07-16T00:00:00Z
B	I	28	2018-07-31T00:00:00Z
B	L	85	2018-07-29T00:00:00Z
C	E	60	2018-07-28T00:00:00Z
C	I	50	2018-08-07T00:00:00Z
C	E	91	2018-08-06T00:00:00Z

I would like to have the drive and product slicers and create a trend line for that product on that drive crossing time.

[v-yulgu-msft · Accepted solution]

Hi @lxiaoxi,

Create measures:

selected Product = SELECTEDVALUE(Table3[Product])

selected Drive = SELECTEDVALUE(Table3[Drive])

Best regards,

Yuliana Gu