Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Data Set:
Document Date Data
5/5/2020 1
5/6/2020 3
5/23/2020 5
6/1/2020 3
6/2/2020 5
6/5/2020 2
7/1/2022 5
7/3/2020 6
Created a Cal date from table from (2010,1,1 to 2030,12,31)
Joined with date and document date.
In the report section i have taken the Date as a filter and when i select the date range 5/1/2020 to 6/5/2020, i want to display two set of data one is
Document Date Data
5/5/2020 1
5/6/2020 3
5/23/2020 5
6/1/2020 3
6/2/2020 5
6/5/2020 2
second i want to displaythis
7/1/2022 5
7/3/2020 6
Solved! Go to Solution.
Hi @Anonymous ,
You can delete the realationship between calendar date and document date, create a control measure like this and set its value as 1 in the visual filter to achieve this:
Visual control =
VAR _max =
CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar'[Date] ) )
RETURN
IF ( SELECTEDVALUE ( 'Table'[Document Date] ) > _max, 1, 0 )
Sample file is attached that hopes to help you, please check and try it: Need help i displaying the data with filter and without filter.pbix
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , not sure what logic of date you wanted for second one , but try like
measure =
var _max = eomonth(maxx(allselected(Date),Date[Date]),0)+1
return
calculate(sum(Table[Data]), filter(all(Date),Date[Date]>=_max))
Thanks for your input, I only want to display the future date based on max date of selected filter.
Example:
Suppose i have selected in filter (1/7/2011 to 6/12/2020)
then my desired result should be
7/3/2020
7/1/2022
Hi @Anonymous ,
You can delete the realationship between calendar date and document date, create a control measure like this and set its value as 1 in the visual filter to achieve this:
Visual control =
VAR _max =
CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar'[Date] ) )
RETURN
IF ( SELECTEDVALUE ( 'Table'[Document Date] ) > _max, 1, 0 )
Sample file is attached that hopes to help you, please check and try it: Need help i displaying the data with filter and without filter.pbix
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
To do this, you typically need a disconnected table. Here is one approach to get your desired result.
1. Make a calculated table with your documents date with no relationship to your original table -
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
82 | |
79 | |
66 | |
49 | |
46 |
User | Count |
---|---|
103 | |
44 | |
39 | |
39 | |
39 |