Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Looking for a solution to display a chart that shows value changes on the respective date.
i.e.
Sales
01 Dec 2023 | 10 | |
05 Dec 2023 | 15 | |
06 Dec 2023 | 15 |
Having the chart display horizontal links between the dates.
the 2nd, 3rd and 4th of December, even there is no value, should be treated as though they have the same value as the 01 Dec, thus only chaning on the 5th when a new different value is present.
Can this be configured directly on a chart visualization or will we need additional measures etc.
Wanting to keep things as simple as possible.
Getting the same value provided in the data set cannot happen, which would resolve this eaily enough.
Solved! Go to Solution.
@techno , Create a date/calendar table and then join the date of your table with date of date table. Use date from date/calendar table in visual, measure, and slicer
Last Sales = CALCULATE(lastnonblankvalues('Date'[Date], SUM(Sales[Amount])) ,filter(all('Date'),'Date'[date] <=max('Date'[date])))
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
@techno , Create a date/calendar table and then join the date of your table with date of date table. Use date from date/calendar table in visual, measure, and slicer
Last Sales = CALCULATE(lastnonblankvalues('Date'[Date], SUM(Sales[Amount])) ,filter(all('Date'),'Date'[date] <=max('Date'[date])))
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
@amitchandak Thank You.
Apologies on the delay
Got this working with a slight adjustment:
Last Sales = CALCULATE(lastnonblankvalue('Date'[Date], SUM('Sales'[Amount])) ,filter(all('Date'),'Date'[date] <=max('Date'[date])))
User | Count |
---|---|
89 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
96 | |
92 | |
91 | |
75 | |
69 |