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.
Is it possible to bookmark to static results? For example...
Say we have a query with some slicers & filters applied that outputs to a grid of columns & rows. When we apply the bookmark all we are really doing is saving the slicer & filter settings not the output. Is it possible to setup a bookmark such that the output will always be the same?
Col1 Col2 Col3
Row1 1 A 1000
Row2 2 B 2000
Row3 3 C 3000
If we apply a slicer that looks for any row where Col3 value > 1000 the result would be Row2 & Row3 and we bookmark that.
Now, if the value of Col3 in Row1 changes from 1000 to 1001 the bookmarked result would contain 3 rows but that isn't what was bookmarked originally. Is it possible to keep the original rows (ignoring individual values) in a bookmark without exporting?
Solved! Go to Solution.
@cymorg Bookmarks capture filter state and return data from the model, they don't store snapshots or capture data states. So, the likely answer is that you can't do what you describe.
@cymorg Bookmarks capture filter state and return data from the model, they don't store snapshots or capture data states. So, the likely answer is that you can't do what you describe.
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.