cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ToddChitt Member
Member

Re: Share your thoughts on the new filter pane

I submitted a bug two days ago about the new Filter pane and how it picked up custom colors from my JSON theme, something that it did NOT do a month ago. It also changed the look on deployed Apps. 

 

To remedy, I need to touch EVERY SINGLE report page and re-format the Filter pane. 

 

Even still, Filter cards that have filter values applied are formatted different than the assigned "Font + icon color".

 

Reference this thread: https://community.powerbi.com/t5/Issues/Custom-Themes-mess-up-Filter-Pane-formatting/idc-p/767091#M4...

 

 

Also, there should be a GLOBAL formatting option for the Filter Pane: A place to set it ONCE for the entire MODEL, and NOT have to set it for each and every page. Can you do that in the JSON file? If so, it needs to be different than the standard Background and Foreground elements. 

Kris_A Frequent Visitor
Frequent Visitor

Re: Share your thoughts on the new filter pane

Hi,

 

I think the new filter pane is a great improvement over the previous way of working, but I think there is room for improvement.

 

1. The biggest "issue" I have with the filter pane is the two different ways of searching : one for numbers and one for text. For example : I want to search for one specific OrderID, but the OrderID is a numerical field : this is not intuitive. 

 

2. Also if I search in my Product field for, let's say, "Bike", then I want to select all Bike products with one click. Not selecting all 150 Bike products one by one. (I know for this use case you'd better make a grouping field for selecting the "Bike category", but in real life a business user wants to do this kind of searches for a lots of different use cases / examples, and the data modeler will not always forsee all uses cases.)

PuneethERB Frequent Visitor
Frequent Visitor

Re: Share your thoughts on the new filter pane

Hi !!

Requesting for the update where we'll be able to copy the style (ex: Coloring or Formatting) defined in one page to the panes on different pages in the same file.

Abraxus Frequent Visitor
Frequent Visitor

Re: Share your thoughts on the new filter pane

Hi @ToddChitt, that's been possible for some time I think, and it does apply to the whole Power BI document (I'm assuming we're both referring to Power BI desktop app [with publishing online done after the fact]). Also, Microsoft revealed in a recent update how to control the different card states as well.


I gave some further details here:

https://community.powerbi.com/t5/Desktop/JSON-theme-incorporating-format-cards-using-selector-settin...

 

(This also accounts for the filter pane background of course, which can be a different colour to the main report background if desired.)

Hopefully that helps!

 

For my part, I think the filters are okay [and very useful for basic 'background' custom calculations/scenarios that don't justify DAX/Power Query but would require it otherwise], however there needs to be a LOT more control over what appears in the 'user facing' filters where used (for example someone mentioned the number of rows being displayed for each category in categorical lists, well not only should there be an option to turn that off but having it switched off should be the default). Also, given how popular it is, not having the 'slider' option for date/numerical values seems an odd oversight.

 

Note/Edit: Oh I just remembered, Microsoft also made an update (sometime before the August one) that further 'refined' the font sizes in Power BI, to bring the Filter cards/pane more in line with the other visuals (immediately before that they made most of the fonts more consistent, but the filter[s] were among the items left out at the time). This may be another reason for the font issues you've had (I had to rebuild the company JSON theme file twice specifically for those reasons so I can speak to the effect it had with some detail), so worth keeping mind.

ToddChitt Member
Member

Re: Share your thoughts on the new filter pane

The site linked from Power BI Desktop ( https://docs.microsoft.com/en-us/power-bi/desktop-report-themes ) is out of date and has no reference to Themes or the "outspacePane" seciton as described in the May blog post. 

 

Question: Why are there nested "*": {...} sections? What does each level of the outline refer to?

Super User
Super User

Re: Share your thoughts on the new filter pane

@edhans 

Agree. I also liked previous versions better, where the filters were at the lower half of the visualizations pane  

 

jiv Frequent Visitor
Frequent Visitor

Re: Share your thoughts on the new filter pane

My thoughts exactly.

Abraxus Frequent Visitor
Frequent Visitor

Re: Share your thoughts on the new filter pane

Hi @ToddChitt,

 

Yes I've had to figure out a lot of the JSON syntax for myself over the past year, and even though they recently updated the theme page you linked to it's still out-of-date, I was hoping it would have been updated in more meaningful fashion, but they might be waiting for the September update (which apparently will significantly enhance/improve general formatting options, even negating the need for the JSON theme file to an extent).

 

Anyhow, to your other question, the main wildcard "*" level is a bit ambiguous, though apparently this styleName value/level does perform some function in rare circumstances. In my own JSON file[s] though I've never had anything but the asterisk in there, but it is a necessary level to account for.

Otherwise, using the different levels of the page background as a simple example, this translates thus:

visualStyles: {
    visualName: {
        styleName: {
            cardName: [{
                propertyName: propertyValue
            }]
        }
    }
}

EQUALS (using page background colour and transparency as an example)

visualStyles: {
   "page":{
      "*":{
         "background":[{
            "color":{
               "solid":{
                  "color":"#ffffff"
               }
            },
            "transparency":0
         }]
      }
   }
}

Note that some values, in this case color, require extra property levels before you get to the actual value. Also, the filter properties introduce another (semi-nested?) level relating to the different filter panel states (available/applied).

tex628 New Contributor
New Contributor

Re: Share your thoughts on the new filter pane

I have a concern, in some report I'm using page level filters instead of slicers due to a lack of space. 
When you have no visual selected this works very well but if the user selects a visual they will have all of the visual level filters appear. 

Toggling visibility on all visuals in a large report is very tedious, so it would be very nice if you could toggle off visibility on ALL visual level filters on a report. 

 

Br,
J

PuneethERB Frequent Visitor
Frequent Visitor

Re: Share your thoughts on the new filter pane

My thoughts exactly.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 426 members 4,138 guests
Please welcome our newest community members: