Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I have a measure which is simply a division equation such as sum(value)/measure2 = final result. It works perfect, however the input on measure2 is a fixed number pulled (manually) from a data table where it has a Date field and the Value field. Simplified, it looks like this (it is daily data):
Date Value
1/1/2000 102.4
1/2/2000 105.6
1/3/2000 107.3
I have a date slicer, which slices my chart based on the data above, also no issues with this. The division equation previously stated is as follows: sum(value) / measure2 where measure2 = 102.4.
What I want to know is how to allow the Date slicer to auto update measure2 to the new minimum value selected by the user. For example, the date slicer defaults to 1/1/2000 based on the data but if the user changed it to 1/3/2000, I want measure2 to not be 102.4 but 107.3 and thus produce a different result in the final result equation.
Solved! Go to Solution.
You can try and format your slicer to use the single-select option, and then use SELECTEDVALUE(Table[Value]) instead of measure2.
You can try and format your slicer to use the single-select option, and then use SELECTEDVALUE(Table[Value]) instead of measure2.
Hi - a follow up. Is there a way to allow my x axis to only display the dates >= to the selected date? Based on the example above, the selected values work as intended per your suggestion, however my x axis will still display 1/1/2000, 1/2/2000, 1/3/2000 etc. So, if the selected date is 1/2/2000 (and therefore the value is 105.6), I want my x axis to exclude/slice out anything <= 1/2/2000.
Very helpful, thank you!
User | Count |
---|---|
120 | |
72 | |
69 | |
57 | |
50 |
User | Count |
---|---|
167 | |
82 | |
68 | |
65 | |
53 |