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 Experts
I am trying to filter my data using a month slicer - however it onlu gives me the values fro Mar 21 and the slicer returns back zero values of all other periods in 2021.
Sample file
https://www.dropbox.com/s/xcuyv21vuz9vg51/test_.pbix?dl=0
Solved! Go to Solution.
@Anonymous , Try
lastest month = month(maxx(allselected('Date'), 'Date'[Date])) -1
or
lastest month = month(maxx(allselected('DimDate'), 'DimDate'[Date]))
let rest be the same as of now
Hi, @Anonymous
Please try to change your filter like below.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi Kim - Not working giving me a constant value..
@Anonymous , In all you Measures in the table you have filtered on lastest month , which based on today().
Ideally it should be maxx(allselected('Date'), 'Date'[Date]), if you want slicer to work
Can you kindly post the full measure here and i should be able to do the rest.
Thanks
@Anonymous , Try
lastest month = month(maxx(allselected('Date'), 'Date'[Date])) -1
or
lastest month = month(maxx(allselected('DimDate'), 'DimDate'[Date]))
let rest be the same as of now
thank you amit
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.
User | Count |
---|---|
97 | |
95 | |
76 | |
72 | |
65 |
User | Count |
---|---|
140 | |
109 | |
103 | |
82 | |
73 |