Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Previous 3 months transaction amount even after selecting a month in slicer

Please find the data model.

Srikrishna565_0-1637756225183.png

the scenario is, I need to see past 3 months data when I select a month in slicer,

For example, If I select november 2021, the Column Chart should diplay Nov,Oct,Sep of 2021.
The Date table is not connected directly to Transaction table.
Note: I have other visuals on the page along with the column chart.. Those visuals need to show monthly data(not last 3 months) data.

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

I think the below is what you want  :

vluwangmsft_0-1638265500099.png

vluwangmsft_1-1638265521503.png

vluwangmsft_2-1638265560607.png

 

 

To learn more detail ,you could download pbix file.

 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

View solution in original post

3 REPLIES 3
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

I think the below is what you want  :

vluwangmsft_0-1638265500099.png

vluwangmsft_1-1638265521503.png

vluwangmsft_2-1638265560607.png

 

 

To learn more detail ,you could download pbix file.

 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

amitchandak
Super User
Super User

@Anonymous , if you select one month and want to display more than month, use an independent table

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

Anonymous
Not applicable

Thanks @amitchandak for the reply.
But I got problems with this scenario.

1)In your model date table is directly connected to Sales, In my case I have intermediate table(ledger),Please see the above model.

2)If I take a independent date table's date in the slicer, that will effect my other visuals in the page.

 

Thanks,

SriKrishna

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.