Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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
@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
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 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
63 | |
34 | |
32 | |
28 | |
27 |
User | Count |
---|---|
57 | |
50 | |
39 | |
15 | |
12 |