Forum Discussion
Solved
Get Selected Value Based on Two Slicers
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.
Hi lxiaoxi,
Create measures:
selected Product = SELECTEDVALUE(Table3[Product]) selected Drive = SELECTEDVALUE(Table3[Drive])
Best regards,
Yuliana Gu
1 Reply
Hi lxiaoxi,
Create measures:
selected Product = SELECTEDVALUE(Table3[Product]) selected Drive = SELECTEDVALUE(Table3[Drive])
Best regards,
Yuliana Gu