Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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.

  • Anonymous's avatar
    Anonymous
    3 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

  • Anonymous's avatar
    Anonymous
    Not 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. 

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you Anonymous ,

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