Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Guys, We have a report and the powers that be have requested they see the last three month on the chart as default but that they would like to be able to see any other selected dates through a slicer.
So when loading the app see the last three months but then maintain the ability through a pre-existing slicer to choose and alternative date selection.
Any suggestions on how this can be achieved?
Thanks,
Alex
Solved! Go to Solution.
Hi @Alex1988 ,
Not sure if i understand you correctly, but you may check the following steps.
1# Create a table as below and use slicer column as slicer.
2# Create a measure like below.
Measure = IF(MONTH(TODAY())-MONTH(SELECTEDVALUE('Table'[date]))<SELECTEDVALUE(slicer[value]),SELECTEDVALUE('Table'[value]),BLANK())
3# Create the visual like below.
Best Regards,
Jay
Hi @Alex1988 ,
Not sure if i understand you correctly, but you may check the following steps.
1# Create a table as below and use slicer column as slicer.
2# Create a measure like below.
Measure = IF(MONTH(TODAY())-MONTH(SELECTEDVALUE('Table'[date]))<SELECTEDVALUE(slicer[value]),SELECTEDVALUE('Table'[value]),BLANK())
3# Create the visual like below.
Best Regards,
Jay
@Alex1988 , Use relative date slicer
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Create a column like this in you table
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"2nd Last Month" ,
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)
and sort on
Month Year sort = FORMAT([Date],"yyyymm")
And select This Month, Last Month and 2nd Last Month
Or try this
https://www.youtube.com/watch?v=duMSovyosXE
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |