Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
Thank you @v-tangjie-msft ,
The measure is a clean alternative greatly appreciated! Formula is easy enough to calculate.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |