The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I have the following graph (as example) and the date selection now has all the dates known.
I have the following wish from a customer and that is to have a default date set on 30 days.
Now i can do that with a filter on the page like below...
BUT.. now comes the questionable part... He also wants to be able to change the date selection and see further back.
but if you change the date from 12-4 to 1-4 for instance, nothing happens because there is a filter on the date.
Does anybody have a brilliant solution without changing the datepicker itself.
Hi @Karola ,
Since you set the relative date filter on this report page, all the visuals on this page would be affected by this page filter instead of the visual filter.
In addition, relative date and normal date filter could not be used at the same time in the visual. If wants to filter visual by slicer in 30 days, you can create a measure like this, put it in the visual filter and set its value as 1:
visual control =
VAR _maxdate =
CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) )
RETURN
IF (
SELECTEDVALUE ( 'Table'[Date] ) >= _maxdate - 30
&& SELECTEDVALUE ( 'Table'[Date] ) <= _maxdate,
1,
0
)
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
this will not really fix my problem. because it only works when using the date with a before and it only shows the 30 days before that date.. i just want to use the between date and have a default 30 days when i open.. but then be able to change the date selection. so i want to see from 1-1 till 15-5 that should be possible, but everytime i open the report it shows the last 30 days.
@Karola , Independent date table can help (Select a range/date and show more or less dates on axis) , refer to my video if that can help you
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
User | Count |
---|---|
82 | |
81 | |
35 | |
32 | |
32 |
User | Count |
---|---|
93 | |
79 | |
62 | |
54 | |
51 |