line graphchange as per slicer

[Anonymous]

hiiii  i am attaching my pbix file as well

i have a line graph and a slicer

in my slicer i am using relative date slicer 

what i want to do is if i select  weeks in slicer my line graph should display past 2 weeks and current week data

if i select a month in my slicer my line graph should display past 2 months and cuttent month data

https://drive.google.com/file/d/1dcyfSgtGtc6acwq24Rm4JEk3czdrlGrc/view?usp=sharing 

[FrankAT]

Hi @Anonymous 

your slicer is set relativ to date and filters your chart to only one datapoint in year 2020. Change the behavior of your slicer or disconnect its filtering in tab Format > Edit interactions from the line chart.

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Anonymous]

hiii frank

i want my data in the line graph to be changed as per my slicer and display past 2 and presen months or weeks data

[FrankAT · Accepted solution]

Hi @Anonymous 

don't use the implicite calendar build by Power BI Desktop. Build your own calendar and use it in your data model in relationship with the other tables. So you have full control on your data.

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)