The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi,
I have dashboard with four buttons and i am showing charts for 6Month,18Month & 30Month finally there is All button user can able to navigate from one button to another button based on that the filters will change dynamically.
For Example: If user select all button it will show the all records with historic data or else if user select 6M button it will show the max date(current date) last 6 months data similar to 18M & 30M.
the question is when am filtering the values in any slicer its working properly but one scenario its not working as expected. Consider clicking 6M button its showing records for 6M alone if i have navigate to first tab and selecting year as 2010 it wont show any record in 6M chart but my requirement is to reset the filter and show the 6M data in chart because its showing empty.
In drop down it shows 2018 but its also have 2010 year the reason is we selected 2010 in first tab and its in report level filter.
Note: Here I have to used report level but we no need to use page level filters as per our requirement.
any idea to overcome to this issue to reset the filters to existing state.
Regards,
Yuvaraj
@Anonymous,
You may try adding another button to reset the slicers.
Thanks for your response.
Yes we can create but am expecting without creating another button we cant able to reset the slicer.
Regards,
Yuvaraj
User | Count |
---|---|
64 | |
55 | |
53 | |
50 | |
31 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
45 |