Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a SalesFact table ranging data from 2009 Q1 and data will be added every Quarter.
But I wanted to display values only from 2019.Q1 in Slicer. But when I select Snapshot_Year, it is displaying from 2009.
I do not want to use Page/Report level filters as these reports are 3-year, 10-Year and Trend reports means if a user selects 2019.Q1, we use data from 2009.Q1 for 10-year avergae reports.
we are using Power BI Report Server Jan 2019 version.
Thanks,
Kumar
Solved! Go to Solution.
Sorry for not marking answer.
I have added another Date Slicer and selected 'After' option to select From date range and hided in SELECTION pane.
While calculating LYTotals am ignoring the slicer and it worked.
Thank you again.
Hi @Anonymous
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution. if not, please share more details about your question, we'd like to provide further support. thanks!
If you've fixed by your own, it would be much appreciated if you can share your solution here.
Sorry for not marking answer.
I have added another Date Slicer and selected 'After' option to select From date range and hided in SELECTION pane.
While calculating LYTotals am ignoring the slicer and it worked.
Thank you again.
Hi @Anonymous ,
Not sure if you'd like to use the slicer to filter the data from 2019 Q1 until now, if yes, you can try below default slicer and the custom slicer (Timeline)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |