cancel
Showing results for 
Search instead for 
Did you mean: 

Bug/error with the New Filter Experience in Power BI Service

I found a bug/error with the New Filter Experience in Power BI Service. When using the filter pane in PBI Desktop it works fine, but when I Publish the PBIX-file (Import data) to the PBI Service the filter pane is not reacting well (see picture below).

I have three bookmarks in the report, I don’t know if that is a part of the issue.

 

I really like the “New Filter Experience” and I know it’s still a Preview feature, but it would be great if this bug/error could be solved in the nearby future.  

 

I've installed the latest PBI desktop (downloaded 2019-01-30) and bulid and published the report from that version.

 

The new filter experience not working.PNG

Status: Accepted
Comments
Moderator

Hi @PBI_Jake,

 

I'm not able to reproduce the issue on my side. Please try in different browsers to see if the same issue occurs. 

 

If possible, please share pbix file with us. You can upload it to your OneDrive and send the share link to me via private message. 

 

Best Regards,
Qiuyun Yu

Visitor

Hi Qiuyun Yu, 

 

Thx for your reply. The issue still remains when using the report in other web browsers. 

 

Unfortunately, I can’t share the PBIX-file as it contains confidential information (both rows and column names).

 

Hopefully the issue will solve in future releases of the New filter pane.

 

Br,

Jacob

Visitor

Hi again Qiuyun Yu,

 

During the weekend something must have hapened in the PBI Service. All of my published reports that
uses the New Filter Experience in Power BI Service has gone blank (i.e. The New Filter Pane has gone blank). Even on reports that I've published on January 18th, that worked fine prior this weekend has gone blank. 

 

The filter function still work in PBI mobile apps. 

 

I've just tried published a PBIX-file with dummy data Type: "Enter Data" (import), and the same error occur

on that file.

 

Please see picture below.

I've also shared the PBIX-file (with dummy data) through this JumpShare-link:

https://jmp.sh/HTufiJS

 

P.S

When you expand/collapse the Filter Pane the error comes and goes.. 

D.S

 

PPS.

We have a special Theme imported (JSON) in the PBIX.. If that can be the issue (see code under the picture)?

 

Br,

Jacob

FilterError.PNG

 

{
"name":"Theme 2018",
"dataColors":
["#2f65a4","#0aa7e0","#fcc00d","#71ae47","#ee7e32","#a3a4a4","#45358b","#3e2535","#3599B8","#DFBFBF","#4AC5BB","#5F6B6D","#FB8281","#F4D25A","#7F898A","#A4DDEE","#FDAB89","#B687AC","#28738A","#A78F8F","#168980","#293537","#BB4A4A","#B59525","#475052","#6A9FB0","#BD7150","#7B4F71","#1B4D5C","#706060","#0F5C55","#1C2325","#7D3231","#796419","#303637","#476A75","#7E4B36","#52354C","#0D262E","#544848","#016AB8","#373D49","#FDB15D","#AAF20F","#5F646D","#8AA3EB","#FEE266","#A6687A","#3557B8","#DFCFBF","#4A91C5","#5F646D","#FBBF81","#C9F459","#7F838A","#A4B8EE","#FDE489","#B68794","#28428A","#A79B8F","#165889","#292E37","#BB824A","#8DB525","#474A52","#6A7CB0","#BDA750","#7B4F5A","#1B2C5C","#706860","#0F3C5C","#1C1E25","#7D5731","#5D7918","#303237","#475375","#7E6F36","#52343D","#0D152E","#544E48","#010EB8","#393749","#F9FD5D","#38F20F","#615F6D","#A08AEB","#CEFE66","#A67668","#5435B8","#DFDFBF","#4A53C5","#615F6D","#FAFB81","#7CF459","#807F8A","#B5A4EE","#DBFD89","#B69087","#3F288A","#A7A78F","#161F89","#2A2937","#BBBB4A","#45B525","#494752","#7A6AB0","#9CBD50","#7B594F","#291B5C","#707060","#0F155C","#1E1C25","#7C7D31","#2D7918","#303037","#514775","#697E36","#523B34","#140D2E","#545448","#4E01B8","#423749","#A9FD5D","#0FF256","#675F6D","#D18AEB","#82FE66","#A69468","#9535B8","#CFDFBF","#7D4AC5","#675F6D","#BCFB81","#59F484","#857F8A","#DAA4EE","#A1FD89","#B6A887","#6F288A","#9BA78F","#461689","#322937","#82BB4A","#25B54C","#4E4752","#9E6AB0","#65BD50","#7B6E4F","#4A1B5C","#687060","#2E0F5C","#221C25","#567D31","#187934","#343037","#684775","#457E36","#524934","#250D2E","#4E5448","#AA01B8","#493746","#5DFD62","#0FF2C7","#6D5F6B","#EB8AD3","#66FE96","#99A668","#B83598","#BFDFBF","#BA4AC5","#6D5F6B","#81FB82","#59F4D1","#8A7F89","#EEA4DD","#89FDAA","#ACB687","#8A2873","#8FA78F","#801689","#372934","#4ABB4A","#25B594","#524750","#B06A9F","#50BD70","#717B4F","#5C1B4D","#607060","#540F5C","#251C22","#317D32","#187964","#373036","#75476A","#367E4A","#4C5234","#2E0D26","#485448","#B8016A","#49373D","#5DFDB1","#0FAAF2","#6D5F64","#EB8AA3","#66FEE2","#7AA668","#B83557","#BFDFCF","#C54A91","#6D5F64","#81FBBF","#59C9F4","#8A7F83","#EEA4B8","#89FDE5","#94B687","#8A2842","#8FA79B","#891658","#37292E","#4ABB82","#258DB5","#52474A","#B06A7C","#50BDA7","#5B7B4F","#5C1B2C","#607068","#5C0F3C","#251C1E","#317D58","#185D79","#373032","#754752","#367E6F","#3D5234","#2E0D15","#48544E","#B8010E","#493937","#5DF9FD","#0F38F2","#6D615F","#EBA08A","#66CEFE","#68A676","#B85435","#BFDFDF","#C54A53","#6D615F","#81FAFB","#597CF4","#8A807F","#EEB5A4","#89DBFD","#87B691","#8A3F28","#8FA7A7","#89161E","#372A29","#4ABBBB","#2545B5","#524947","#B07A6A","#509CBD","#4F7B58","#5C291B","#607070","#5C0F15","#251E1C","#317C7D","#182D79","#373030","#755147","#36687E","#34523B","#2E140D","#485454","#B84E01","#494337","#5DA9FD","#560FF2","#6D685F","#EBD18A","#6681FE","#68A694","#B89535","#BFCFDF","#C57D4A","#6D685F","#81BCFB","#8459F4","#8A857F","#EEDAA4","#89A1FD","#87B6A8","#8A7028","#8F9BA7","#894616","#373229","#4A82BB","#4D25B5","#524E47","#B09E6A","#5065BD","#4F7B6F","#5C4A1B","#606870","#5C2E0F","#25221C","#31567D","#341879","#373430","#756947","#36447E","#345249","#2E250D","#484E54","#B8A901","#464937","#615DFD","#C70FF2","#6B6D5F","#D4EB8A","#9666FE","#6898A6","#99B835","#BFBFDF","#C5BA4A","#6B6D5F","#8181FB","#D159F4","#898A7F","#DDEEA4","#AA89FD","#87ACB6","#738A28","#8F8FA7","#897F16","#353729","#4A4ABB","#9425B5","#505247","#9FB06A","#7050BD","#4F717B","#4D5C1B","#606070","#5C540F","#23251C","#31317D","#641879","#363730","#6A7547","#4B367E","#344C52","#262E0D","#484854","#6AB801","#3D4937","#B15DFD","#F20FAA","#646D5F","#A3EB8A","#E266FE","#687AA6","#57B835","#CFBFDF","#91C54A","#646D5F","#BF81FB","#F459C9","#838A7F","#B7EEA4","#E589FD","#8794B6","#428A28","#9B8FA7","#588916","#2E3729","#824ABB","#B5258D","#4A5247","#7CB06A","#A750BD","#4F5B7B","#2C5C1B","#686070","#3C5C0F","#1E251C","#57317D","#79185D","#323730","#537547","#6F367E","#343D52","#152E0D","#4E4854","#0FB801","#37493A","#FD5DF9","#F20F39","#5F6D61","#8AEBA1","#FE66CE","#7568A6","#35B854","#DFBFDF","#54C54A","#5F6D61","#FB81FA","#F4597C","#7F8A80","#A4EEB5","#FD89DB","#9187B6","#288A3F","#A78FA7","#1F8916","#29372B","#BB4ABB","#B52544","#475249","#6AB07B","#BD509B","#594F7B","#1B5C2A","#706070","#155C0F","#1C251E","#7D317B","#79182D","#303731","#477552","#7E3668","#3B3452","#0D2E14","#544854","#01B84E","#374942","#FD5DA9","#F2560F","#5F6D67","#8AEBD1","#FE6682","#9468A6","#35B895","#DFBFCF","#4AC57D","#5F6D67","#FB81BD","#F48459","#7F8A85","#A4EEDA","#FD89A1","#A887B6","#288A6F","#A78F9B","#168946","#293732","#BB4A82","#B54C25","#47524E","#6AB09D","#BD5065","#6E4F7B","#1B5C4A","#706068","#0F5C2E","#1C2522","#7D3156","#793418","#303734","#477568","#7E3644","#493452","#0D2E25","#54484E"],
"background":"#FFFFFF",
"foreground":"#53a093",
"tableAccent":"#48b5e5",

"visualStyles":{
        "*":{
            "*":{
                "*":[{
                    "responsive":true,
        "wordWrap":true,
     "fontFamily":"Segoe UI"
                }],
       "wordWrap":[{
        "show":true
                }],
                "labels":[{
                    "show":false,
                    "labelOrientation":"vertical"
                }],
                "categoryAxis":[{
                    "showAxisTitle":false
                }],
                "valueAxis":[{
                    "showAxisTitle":false
                }]
      }
     },
     "scatterChart":{
      "*":{
       "fillPoint":[{
        "show":true
    }]
      }
     },
  "lineChart":{
            "*":{
                "legend":[{
                    "show":true,
     "position":"Top",
     "fontSize": 8
                }],
    "categoryAxis":[{
     "show":true,
     "fontSize":9
    }],
    "valueAxis":[{
     "show":true,
     "position":"Left",
     "fontSize": 9,
     "gridlineStyle":"dotted"
    }],
    "plotArea":[{
     "transparency":92
    }],
    "border":[{
     "show":false
    }],
    "background":[{
     "show":true
    }]
   }     
        },
   "barChart": {
            "*": {
                "labels": [{
                        "show": true
                    }],
                "dataLabels": [{
                        "show": false
                    }],
                "categoryAxis": [{
                        "axisType": "Categorical"
                    }]
            }
        },
  "slicer": {
            "*": {
                "selection": [{
                        "singleSelect": false,
                        "selectAllCheckboxEnabled": true
                    }],
                "header": [{
                        "show": true,
      "outline": "None",
      "fontSize": 8
                    }]
            }
        },
  "map": {
   "*": {
    "mapStyles": [{
      "mapTheme": "grayscale"
      }]
    }
   },
  "tableEx": {
   "*": {
                "*":[{
                    "fontSize":9,
     "fontColor":{"solid":{"color":"#203461"}}
                }],
                "grid": [{
                        "outlineColor": { "solid": { "color": "#0D8ACB" } }
                    }],
                "subTotals": [{
                        "columnSubtotals": false
                    }],
                "columnHeaders": [{
      "wordWrap":true ,
      "backColor": "#ffffff",
      "fontColor": "#203461",
      "gridVerticalWeight":3,
      "stepped":true,
      "steppedLayoutIndentation":25,
      "urlIcon":true
                        }],
     "values": [{
      "fontColorPrimary":{"solid":{"color":"#203461"}},
      "backColorPrimary":{"solid":{"color":"#ffffff"}},
      "fontColorSecondary":{"solid":{"color":"#203461"}},
      "backColorSecondary":{"solid":{"color":"#f3fafe"}},
      "wordWrap":true,
      "urlIcon":true
                    }],
                "rowHeaders": [{
      "wordWrap":true ,
      "backColor": "#ffffff",
      "gridVerticalWeight":3,
      "stepped":true,
      "steppedLayoutIndentation":25,
      "urlIcon":true
                        }]
            }
        },
   "pivotTable": {
            "*": {
                "*":[{
                    "fontSize":9,
     "fontColor":{"solid":{"color":"#203461"}}
                }],
                "grid": [{
                        "outlineColor": { "solid": { "color": "#0D8ACB" } }
                    }],
                "subTotals": [{
                        "columnSubtotals": false
                    }],
                "columnHeaders": [{
      "wordWrap":true ,
      "backColor": "#ffffff",
      "gridVerticalWeight":3,
      "stepped":true,
      "steppedLayoutIndentation":25,
      "urlIcon":true
                        }],
     "values": [{
      "fontColorPrimary":{"solid":{"color":"#203461"}},
      "backColorPrimary":{"solid":{"color":"#ffffff"}},
      "fontColorSecondary":{"solid":{"color":"#203461"}},
      "backColorSecondary":{"solid":{"color":"#f3fafe"}},
      "wordWrap":true,
      "urlIcon":true
                    }],
                "rowHeaders": [{
      "wordWrap":true ,
      "backColor": "#ffffff",
      "gridVerticalWeight":3,
      "stepped":true,
      "steppedLayoutIndentation":25,
      "urlIcon":true
                        }]
            }
        },
  "kpi": {
            "*": {
                "status": [{
      "direction": "Negative",
                        "goodColor": { "solid": { "color": "#73BCB2" } },
                        "badColor": { "solid": { "color": "#EB5D68" } },
                        "neutralColor": { "solid": { "color": "#FFE264" } }
                    }]
            }
        },
        "card":{
            "*":{
                "labels":[{
                    "fontSize":10
                }],
                "categoryLabels":[{
                    "fontSize":9
                }]
            }
        },
   "clusteredBarChart": {
            "*": {
                "labels": [{
                        "fontSize": 10
                    }],
                "valueAxis": [{
                        "show": true,
      "fontSize":10
                    }],
                "categoryAxis": [{
                        "show":true,
      "fontSize":10
                    }]
            }
        },
        "areaChart": {
            "*": {
                "labels": [{
                        "show": false
                    }],
                "dataLabels": [{
                        "show": false
                    }]
            }
        },
        "donutChart":{
            "*":{
                "legend":[{
                    "show":true
                }],
                "labels":[{
                    "labelStyle": "Percent of total"
                }]
            }
        },
        "pieChart":{
            "*":{
                "legend":[{
                    "show":true
                }],
                "labels":[{
                    "labelStyle": "Category, percent of total"
                }]
            }
        },
  "filledMap":{
            "*":{
                "legend":[{
                    "show":true,
                    "labelColor":{"solid":{"color":"#203461"}}
                }]
   }
  }
    }
 }

Visitor

The New Filter pane works again after I removed the JSON-Theme. 

 

Br, 

Jacob

New Member

I  have had the exact same experience. Selecting a filter value was hit and miss and then this week some filters appear just blank.

My reports also were fine in desktop but when published they stop working.

We were using a custom theme. After removing that my report started working.
Thanks for the tip @PBI_Jake.

I have also enabled the query reduction button for filter selections.  This means that the user has an "apply filter" button to ensure that the selection in the filter happens properly.
Br,
Clint

New Member

Same Experiance here , been happening for a few days now. 

Just tested removing the Custom theme , and that seemed to do the trick. 

 

 

Regular Visitor

Experiencing the same issue. Issue started occuring a few days ago.

Frequent Visitor

same here. Using a custom theme + new filter experience causes errors in Power BI service.

Visitor

I can also confirm this being an issue for us.

Moderator

Hi all, 

 

The same issue already reported before internally: CRI 103414505. The fix will reach PROD by end-of-day 2/15 PST.

 

Best Regards,
Qiuyun Yu 

Idea Statuses