Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |