Forum Discussion
Bookmarks & Show items with No Data
Hi PowerBi Gurus,
Trying to get a bookmark to work to change the selected option on the Data "Show Items with No Data".
So far, all attempts have not worked for this specific change - The bookmarks themselves work for other features.
Is this a limitation or what could I be doing wrong?
I could Show/Hide different visuals as a workaround, but trying to avoid in preference of a more elegant solution.
- Anonymous3 years ago
Hi Anonymous ,
Refer this document, when you create a bookmark, the following elements are saved with the bookmark:
So bookmarks can't save the status of "Show items with No Data". You can post your idea to Ideas .
https://ideas.powerbi.com/ideas/
When more people vote for the idea, the product group will likely roll out the feature in a new version.
You can create a measure, then place the measure as a filter in a visual and save it as a bookmark.
Like this:
Measure = IF(MAX('Table'[column])=BLANK(),0,MAX('Table'[column]))If the measure you need are too complex, I think hiding/showing visuals is also a good solution.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- AnonymousNot applicable
Hi Anonymous ,
Refer this document, when you create a bookmark, the following elements are saved with the bookmark:
So bookmarks can't save the status of "Show items with No Data". You can post your idea to Ideas .
https://ideas.powerbi.com/ideas/
When more people vote for the idea, the product group will likely roll out the feature in a new version.
You can create a measure, then place the measure as a filter in a visual and save it as a bookmark.
Like this:
Measure = IF(MAX('Table'[column])=BLANK(),0,MAX('Table'[column]))If the measure you need are too complex, I think hiding/showing visuals is also a good solution.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Thank you Anonymous ,
The measure is a clean alternative greatly appreciated! Formula is easy enough to calculate.