Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @lxiaoxi,
Create measures:
selected Product = SELECTEDVALUE(Table3[Product]) selected Drive = SELECTEDVALUE(Table3[Drive])
Best regards,
Yuliana Gu
Hi @lxiaoxi,
Create measures:
selected Product = SELECTEDVALUE(Table3[Product]) selected Drive = SELECTEDVALUE(Table3[Drive])
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.