Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Please find the data model.
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.
Solved! Go to Solution.
Hi @Anonymous ,
I think the below is what you want :
To learn more detail ,you could download pbix file.
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
@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
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |