Forum Discussion

wittwo_sagra's avatar
wittwo_sagra
Advocate II
2 years ago

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