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

Status: Accepted
by PBI_Jake Visitor on ‎01-31-2019 01:27 AM

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
by Moderator v-qiuyu-msft
on ‎01-31-2019 06:21 PM

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

by PBI_Jake Visitor
on ‎02-01-2019 01:18 AM

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

by PBI_Jake Visitor
‎02-04-2019 01:38 AM - edited ‎02-04-2019 02:14 AM

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"}}
                }]
   }
  }
    }
 }

by PBI_Jake Visitor
on ‎02-04-2019 03:56 AM

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

 

Br, 

Jacob

by cbrooks New Member
on ‎02-05-2019 12:54 AM

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

by jbidwell New Member
on ‎02-05-2019 05:51 AM

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

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

 

 

by bludb1 Regular Visitor
on ‎02-06-2019 04:05 PM

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

by KarinJeppsson Frequent Visitor
on ‎02-07-2019 05:58 AM

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

by rfolkes Visitor
on ‎02-07-2019 01:48 PM

I can also confirm this being an issue for us.

by Moderator v-qiuyu-msft
on ‎02-12-2019 11:49 PM

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