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.
Dear All,
How Do I create two slicers for a report but i can customised each slicer (period) whatever I like?say i have current period and previous period and I can adjust the length of the current and previous period whatever I like (they can be different time in length).
I tried the below but it did not work properly as my two slicers can only adjust the current period data not the previous period data.
https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/
thanks,
Peter
hi, @Anonymous
I also had tried as the article before, and it works well, there should be something wrong in other.
could you share your sample pbix file and expected output for us have a test?
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin
Hi Lin,
I solved this out. However, I do not understand why in the manager relationships, we need to untick the active button between "Previous Date (Date)" and "Date (Date)".
Is it becasue we use the formular "
Hi Lin,
Sorry how Do I upload the files as I cannot see an attachment function?
Thanks in advance.
Peter
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |