Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Experts,
My report has following visual (Slicer : Relative). If I select last 2 months it shows the range at bottom of visul. I want to place this selected range from visual parallel to it. I guess we might achieve this solution using DAX. Below is the screenshot for reference:
I tried using following DAX :
Measure = IF(ISFILTERED(d_Date[Data View Range]),CONCATENATEX(VALUES(d_Date[Data View Range]),d_Date[Data View Range]),"")
And display this above measure on Card Visualization. But it shows all the values (means all 60 dates).
I want only the 1st and the last value displayed using DAX. I am close to the solution but not upto it.
Can someone suggest or help me with this query.
Thanks in Advance..!!
Solved! Go to Solution.
@mwadhwani,
You can directly create the following two measures.
minselecteddate = MIN(d_Date[Data View Range])
maxselecteddate = MAX(d_Date[Data View Range])
Here is an example for your reference.
Regards,
Lydia
how to take the values before min and after max
@mwadhwani,
You can directly create the following two measures.
minselecteddate = MIN(d_Date[Data View Range])
maxselecteddate = MAX(d_Date[Data View Range])
Here is an example for your reference.
Regards,
Lydia
Thanks @v-yuezhe-msft it worked...!!!!. I was thinking alot so created very complex DAX
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
85 | |
69 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |