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 report requirement where I have added a table and lot of measures in that table.I have to show all the measures for a date range = todays date -7.
Is there a way to create a visual level filter on the table or I have to create separate measures to achieve the same.
Regards
Solved! Go to Solution.
Try relative date slicing in visual or page or report level filters
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Try relative date slicing in visual or page or report level filters
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Hi! It deppends on the requirement. If you want to show the last 7 days of the last date in a table of your model, then you can add a visual level filter type "relative" with the date column. If you want last 7 days from NOW(), then you might need to create a column in your table comparing dates like "if you date column > last 7 days then yes else no". You can then add that new column in a visual level filter and check "yes".
Hope this helps, let me know if you need more assistant with the calculated column.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |