Bookmarks & Show items with No Data

[carlG]

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.

[v-tangjie-msft · Accepted solution]

Hi @carlG ,

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. 

[carlG]

Thank you @v-tangjie-msft ,

The measure is a clean alternative greatly appreciated! Formula is easy enough to calculate.