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.
I have the table below that calculates trailing 12 month sales, margin, sales price/lb, cost/lb, etc. The DAX for these measures is basically the same and I have put an example below. All of the fields calculate correctly. The issue arises when I add a sparkline to the table-- the sparkline is displaying ALL months, not just the last 12 months, and this is bogging down the visual. Is there any way that I can limit what the sparkline is displaying? I have tried adding a visual level filter and using a relative date, for dates in the last 12 months; this gives me the desired look, but doesn't update when the date slicer is adjusted. I think what I need is a disconnected date table, but I haven't been able to do that successfully.
Any luck with this? Having the same issue.
Hi @ksoukup ,
Could you pls share your pbix file ,remember to remove confidential data.
Best Regards
Lucien
Getting closer... in the file I created a measure called "Date within 1 Yr from Max", which will give a 1 or 0 value for dates in the last 365 days based on the max slicer selection, see measure and first image.
However, when I add this measure as a visual-level filter (where measure = 1), it clears my table (see second image) 😞
I do not know now if a disconnected date table is the best route, as the main date slicer drives multiple other visuals.