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.
Hi,
I have seen some posts with almost similar questions but I haven't found the solution yet.
https://community.powerbi.com/t5/Desktop/How-to-show-next-2-days-of-selected-date/m-p/335396#M150062
This one seemed close, but it has 3 slicers and I only have one.
So I have
Date | Store Number | Sales |
1-1-2010 | 1 | 1500 |
1-2-2010 | 1 | 1700 |
1-3-2010 | 1 | 1800 |
there are some more stores and some more dates. But I want to select one date and then select 28 days ahead of the selected date in the slicer.
This is my slicer.
The graph should display 28 days after the selected slicer date.
Could someone please help.
Solved! Go to Solution.
Hi @Anonymous ,
Check the following steps.
1# Create a CALENDAR table and use 'CALENDAR'[Date] as slicer.
2# Create a measure as below and add it to the visual filter: measure = 1
Measure = IF(SELECTEDVALUE('Table'[Date])>=SELECTEDVALUE('CALENDAR'[Date])&&SELECTEDVALUE('Table'[Date])<SELECTEDVALUE('CALENDAR'[Date])+3,1,0)
Result would be shown as below and you can change "+3" to "+28" in your scenario.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Well, either create a disconnected date table for your slicer or you will have to use ALL/ALLEXCEPT/REMOVEFILTERS in some sort of measure. I'm not clear on the graph you posted, is that what you want to see or ?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
No the graph, is not what I want to see unfortunately that shows all dates. But once I select a date I want it to show all dates 28 days after the selected date on the slicer. So for example if I select 1-1-2010, I want the graph to show 1-1-2010, 1-2-2010, 1-3-2010, till 1-28-2010
Hi @Anonymous ,
Check the following steps.
1# Create a CALENDAR table and use 'CALENDAR'[Date] as slicer.
2# Create a measure as below and add it to the visual filter: measure = 1
Measure = IF(SELECTEDVALUE('Table'[Date])>=SELECTEDVALUE('CALENDAR'[Date])&&SELECTEDVALUE('Table'[Date])<SELECTEDVALUE('CALENDAR'[Date])+3,1,0)
Result would be shown as below and you can change "+3" to "+28" in your scenario.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Here's my PBIX, hopefully works for you.
Best Regards,
Jay
Hi @Anonymous ,
It should be "," or ";" not ".".
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 |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
151 | |
103 | |
102 | |
87 | |
63 |