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 bar chart which uses a week-end date as a time period in X axis. This is used as a page level filter as well, so as I can select various sdates and reflect that in the chart. However, I'd like to use this Week-End date field as a report level filter, so as when I filter different dates this is relfected to the chart and the other tables of the report as well.
Is this possible? Any ideas would br much appreciated.
Thanks
Solved! Go to Solution.
You can have a column be both a report level filter and a page level filter by just dragging it to the page and report level filters area. Am I missing something?
You can have a column be both a report level filter and a page level filter by just dragging it to the page and report level filters area. Am I missing something?
Thanks @Greg_Deckler. Basically yeah, ignore this. I would be great if I could have a slider which would be used to change the time periods on the X axis and also filter the rest of the rerport. This Week End field is in text format
Did you try using Slicer for that matter?
I tried this https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380786?src=office&tab=Overview @sgsukumaran but didn't work at all
@harrinho it is not very clear what you mean by it doesn't work at all.
Did you looked at the solution proposed by @Greg_Deckler? If you use report level filter, it should filter all the reports.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thanks @parry2k. I mean the custom visual for slicer that I downlaoded didn't work. @Greg_Deckler's solution is fine, but the week days I want to filter is a very long list and not user friendly. That's why I'd like to have a slicer to be able to slice and dice the time periods. This is a text field so I don't know how feasible this is.
Other thatn that, yeah @Greg_Deckler is right
Thanks for the clarification. I guess custom visual you downloaded, it need date field as value to slice the data not your week column, not sure if that is what you doing currently.
Did you tried relative filtering using regular slicer on date field?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I did try to use a date field but the slicer didn't show anything, was completely blank. Didn't try further, will try to save some time to do this again
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 |
---|---|
97 | |
97 | |
82 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |