Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi team,
I am new to Power BI and i have created a column chart where I have a single data table for the past 2 years,i only needed the last 12 months data to show in the chart dynamically to my client
This is my visual
I have created a dax measure for this one
I created this measure and inserted into values in the chart but however i am getting all the data for the past two years. Can anybody help me on this
Solved! Go to Solution.
Hi @Danteee
Hope this helps
Joe
If this post helps, then please Accept it as the solution
Thanks @JoeBarry for your help i will accept your reply as my solution, much appreciated.
Hi @JoeBarry
I have added the total measure in the visual and also added the date in the filter pane selected "is in the last 12 months" and it shows till Oct only, may i know why its showing till oct only
Thanks in advance
Hi @Danteee
Does your table have data from 21/09/2022 to the 30/09/2022? I would say October has data and in the context of the last 12 months including today, then October is correct if there is no data in the range mentioned
Hi @Danteee
Hope this helps
Joe
If this post helps, then please Accept it as the solution