Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
wittwo_sagra
Advocate II
Advocate II

Bookmarks don't remember data (default state = no selection) in Power BI Service

Description:

A bookmark is created with following settings 

 
And this is the state of slicers we want to have saved

 

 

So basically we want the bookmark to remember "no data" setting. And it works in Power BI Desktop!
However, when we switch to Power BI Service, mark something on filters and then use the bookmark to "clear" the selections,aand  it doesn't work. There is only one slicer that somehow works, so we've compared the data from report.json config part. 

And I think we've managed to find an issue

This is the part of the 

"config": "{\"version\":.... - 2nd line in the report.json

Later there is defined a bookmark and we've found that working slicer has following definition

{
"040cdcd018c5cc0b7638": {
"filters": {
"byExpr": [
{
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "SomeValue"
}
},
"Property": "OtherValue"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "slicer",
"objects": {
"merge": {
"data": [
{
"properties": {
"mode": {
"expr": {
"Literal": {
"Value": "'Basic'"
}
}
}
}
}
]
}
},
"activeProjections": {
"Values": [
{
"Column": {
"Expression": {
"SourceRef": {
"Entity": "SomeValue"
}
},
"Property": "OtherValue"
}
}
]
}
}
}
}

And here is the not working definition of a slicer (not working in Power BI Service)

 

---
{"18cfb2943ccec2e18bb0": {
"filters": {
"byExpr": [
{
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "SomeValue"
}
},
"Property": "OtherValue"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "slicer",
"objects": {},
"activeProjections": {
"Values": [
{
"Column": {
"Expression": {
"SourceRef": {
"Entity": "SomeValue"
}
},
"Property": "OtherValue"
}
}
]
}
}
},

 So the only difference is the singleVisual --> Object property. In the working slicer it is defined but in the not working it hasn't been defined ("objects": {},)

We don't know what influences this, because both of the slicers have been saved at the same moment, using the same method. 

But well, we've tried to define the objects property in the not working slicer with the definition from the working slicer and we've got the following 


{
"18cfb2943ccec2e18bb0": {
"filters": {
"byExpr": [
{
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "SomeValue"
}
},
"Property": "OtherValue"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "slicer",
"objects": {
"merge": {
"data": [
{
"properties": {
"mode": {
"expr": {
"Literal": {
"Value": "'Basic'"
}
}
}
}
}
]
}
},
"activeProjections": {
"Values": [
{
"Column": {
"Expression": {
"SourceRef": {
"Entity": "SomeValue"
}
},
"Property": "OtherValue"
}
}
]
}
}
}
}

And vois la, after saving the changes and uploading it to service now both of the filters work and all of the other that didn't still don't get cleared. (Because all the remaining ones don't have objects:{} property defined).

Only when we defined it for a selected one manually it started working in Power BI Service. In Power BI Desktop everything works correctly..

So i assume that Power BI Service is not interpreting the "objects" property set to {} properly and only recognizes that it has to be in "non selected state" when "objects" is defined as described above.

Can you take a look into that? It worked in the past and from some time we have problems with our analytics not working with bookmark properly

4 REPLIES 4
v-nuoc-msft
Community Support
Community Support

Hi @wittwo_sagra 

 

@lbendlin Thank you very much for your prompt reply.

 

Can you tell me if your problem is solved? If yes, please accept it as solution.

 

Regards,

Nono Chen

lbendlin
Super User
Super User

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

having a smiliar problem.  I have a bookmark that does a "clear selection"  on a single slicer that stopped working yesterday.  Works in older versions of PBI desktop but not on the service or in the June version of Desktop.  maybe a bug that hopefully microsoft can fix quickly?

Thank you, I will do that 🙂

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.