The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hey guys !
I am very new to PowerBI. Could you suggest me the Dax functions or the syntax with any examples to solve this issue .
I have to show a line chart visual which shows the previous 7days value and after 7days value of a selected date . So if I select a particular date the measure should filter the visual according to it and show according to the requirement .
Appreciate any help. Thank you ♥️
Solved! Go to Solution.
Hi @prv_1401
This solution uses a disconnected date table called 'Date Selector' (meaning it's a date table without any relationship to another table). The slicer should use this table.
7and7 =
VAR _SelectedDate = SELECTEDVALUE('Date Selector'[Date])
VAR _Dates = DATESBETWEEN('Date'[Date], _SelectedDate - 7, _SelectedDate + 7)
VAR _Result =
CALCULATE(
[Total Sales],
KEEPFILTERS(_Dates)
)
RETURN
_Result
The line chart uses the Date column from the Date table.
Hi @prv_1401
This solution uses a disconnected date table called 'Date Selector' (meaning it's a date table without any relationship to another table). The slicer should use this table.
7and7 =
VAR _SelectedDate = SELECTEDVALUE('Date Selector'[Date])
VAR _Dates = DATESBETWEEN('Date'[Date], _SelectedDate - 7, _SelectedDate + 7)
VAR _Result =
CALCULATE(
[Total Sales],
KEEPFILTERS(_Dates)
)
RETURN
_Result
The line chart uses the Date column from the Date table.
Hi ..Thank you for replying
what if the sales value in the table is percentage % ??
So for instance sales % for eachdate is given. You have mentioned there in dax [total sales] Is that a measure you created? .
In case of % how should I deal with it ?
@PaulOlding
Yes, [Total Sales] is a measure. You can replace it with any measure and the pattern should work, so one that returns a %age will be fine.
If you're very new to Power BI, I would then kindly suggest you should learn a bit about the philosophy of PBI because what you want to do is not the easiest thing under the sun. Here's an example of what you'd need to , more or less, implement: Show last 6 months based on user single slicer selection (youtube.com)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
28 | |
16 | |
15 | |
15 |
User | Count |
---|---|
50 | |
47 | |
41 | |
29 | |
26 |