Tooltip page and datesinperiod with chart visual not working

[matkvaid]

Hi,

i have a tooltip page with table and few measures, scorecard and it all works good. So i tried to add a line chart also - sales from previous 12 months, but something i did wrong: my DAX is CALCULATE(SUM(Fact[Sales]), DATESINPERIOD(Date[Date], MAX(Date[Date]), -12, MONHT))) - in my main report page it is intended to select current or previous month, so with previous selected in tooltip all table measures do wokt, like ytd, previous month and previous year. but in chart it is always one filtered in slicer month. What do i do wrong? Thanks

[v-binbinyu-msft]

Hi @matkvaid ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data or a screenshot of your desired results?

For Sparklines, please refer these documents: Power BI December 2021 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI ,  Create sparklines in a table or matrix in a report (preview) - Power BI | Microsoft Docs

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu

[matkvaid]

I found how to remove filter for sparkline here https://www.youtube.com/watch?v=wmwcX8HvNxc

just have not figured out how to display last 12 months, but at least now it is not just current month, but is still better than nothing 🙂

[matkvaid]

So i think i understand what is the problem - data in measure is correct, tried to add sparklines, but problem is the same: for X axis i selec "year - monh" from calendar table, wich is filtered from my date slicer. Any thougts on how to make x axis of last 12 months year-month names?