Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have PBI desktop v March 2023. We use the import mode to get data.
I am graphing vacation hours taken in the past and future on a line graph and showing a trend line. However managers often enter vacation up to 6 months ahead of time. By default PBI shows all data in the dataset. I only want to graph the values from today and before. How do I do that?
I looked in the Visual properties, under Visual tab, then X-axis, then Range, but I cannot enter a formula of "<=today()". The X-axis is my field "Month (bins)" is is the Startdate field grouped by the month.
I can choose a fixed date in the X-axis properties but that date will never change, the user would have to update that date manually and that is not an option. I just want to exclude future dates, and graph only dates from today and before.
I also have a slicer where I can choose the pay type of "Vacation" or many other pay types like regular hours or overtime hours.
Thank you!
Solved! Go to Solution.
@croberts21 , You can use relative date slicer at visual filter level
or you can have a measure like
calculate([Measure], filter(Date, Date[Date] <= today())
You can also try min and max value measure
min measure = today() -3650
max measure = today()
this will cut axis not data
@croberts21 , You can use relative date slicer at visual filter level
or you can have a measure like
calculate([Measure], filter(Date, Date[Date] <= today())
You can also try min and max value measure
min measure = today() -3650
max measure = today()
this will cut axis not data
Thank you! I actually made a new column:
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |