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.
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:
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 |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
80 | |
67 |