How to format filters so they match visualizations in Microsoft Power BI
Your email has been sent
Power BI offers a lot of formatting flexibility for filters, but it’s nice when those formats match the visualizations. We’ll show you how.
Power BI reports have default formats that you’ll probably want to change occasionally for branding purposes. Regardless of why you change default report formats, you’ll want to use those new formats in other elements, such as filters. Making this change provides a nice, cohesive look to your report and tones down the busy factor, which can distract end users.
SEE: Hiring kit: Microsoft Power BI developer (TechRepublic Premium)
In this tutorial, I’ll show you how to access and change filter format properties in Power BI. We’ll review a simple visualization to discern its formatting and then apply those same formats to an accompanying filter. I’m using Power BI Desktop on a Windows 10 64-bit system. You can download a Microsoft Power BI demonstration file for this tutorial.
Jump to:
Adding a filter is automatic. When you add a visual to the report, Power BI adds a filter to the Filters pane that includes every field in the visual. To build a custom filter, drag other fields into buckets on the Filters pane, which you can distribute to the visual, page or even report level.
Figure A shows a simple published report with two visuals and a filter. As you can see, the Filters pane doesn’t match the report. It isn’t horrible — you can leave it that way, or you can update the pane’s formatting to match the visuals.
Figure A
If you click the visual to the right, the Fields pane displays the fields this visual is based on, Amount and Date — Month. If you click the visual to the left, the Fields pane displays Amount and Region. These are the default filters based on each visual’s underlying fields. For our purposes, we don’t need other filtering fields, but your report might have one or more.
In Power BI Desktop, you can use the Visualizations pane to find the visual formats you want to use on the Filters pane. It would be great if you could use Format Painter, but it doesn’t work that way. If you’re familiar with Power BI’s default settings, you can see with a glance that this report has a few custom formats:
There could be many other formats to match, but we’re keeping things simple on purpose. Once you know where to find format settings, matching them is easy.
Now let’s find the settings and document them. To do so, click the treemap visual on the right and make sure the Visualizations pane is open. At the top of the Visualizations pane, click the Format option. Click Visuals in the submenu, and Power BI displays four formatting sections, as you can see in Figure B.
Figure B
You might think that the background color is in the Color section, but that section lists the colors displayed by the chart series. The other possibility is Category Labels, where you’ll find Values. You can see that the values in this visual are using Lucida Sans Unicode at 20 points. Make a note of that if it will be necessary for you to remember later.
Now that we know how to format the text, let’s find that background color. To do so, click the background and then choose General from the submenu in the Visualizations pane. Doing so updates the sections, as you can see in Figure C. Expand the top section, Page Properties, and then open the Wallpaper subsection to find the background color.
Figure C
At this point, you’ll have to dig a bit deeper to make sure you match the exact color as follows:
Figure D
Now, let’s use what we’ve learned to format the Filters pane.
We only have three formats to change for the Filters pane: The font, the font size, and the background or wallpaper color. There’s no Format option on the Filters pane; the settings are in the Visualizations pane.
To change the Filters pane format settings, click anywhere inside the report’s background, and then do the following:
Figure E
Open the Filters pane, and you’ll see that it uses the settings you changed, as shown in Figure F.
Figure F
You might want to reduce the font size a bit, but that’s up to you. Figure G shows the formatted Filters pane, published.
Figure G
You can’t change the entire look of the Filters pane. These are the elements you can change:
When reviewing the visuals, keep this list in mind so you don’t spend time looking for settings that you can’t change. Matching the format of the Filters pane to the visuals or report won’t make filtering easier, but matching reports and panes improves consistency, and it improves the Microsoft Power BI experience for end users.
Read next: Best business intelligence tools (TechRepublic)
From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays
From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays
How to format filters so they match visualizations in Microsoft Power BI
Your email has been sent
TechRepublic Premium content helps you solve your toughest IT issues and jump-start your career or next project.
This is a comprehensive list of the best AI art generators. Explore the advanced technology that transforms imagination into stunning artworks.
Find the perfect payroll service for your business without breaking the bank. Discover the top cheap payroll services, features, pricing and pros and cons.
Is NordVPN worth it? How much does it cost and is it safe to use? Read our NordVPN review to learn about pricing, features, security, and more.
Free project management software provides flexibility for managing projects without paying a cent. Check out our list of the top free project management tools.
Australian and New Zealand enterprises in the public cloud are facing pressure to optimize cloud strategies due to a growth in usage and expected future demand, including for artificial intelligence use cases.
Zero-trust security operates on the fundamental premise that trust should never be assumed, regardless of whether a user or device is inside or outside the corporate network. In this TechRepublic Premium guide, we will explore the benefits of incorporating zero-trust security into your organization’s cybersecurity framework to prevent data breaches and strengthen the protection of …
Every organization relies on data that must be protected and backed up in a reliable and secure way by authorized personnel. While the content or criticality of the data may vary, the processes behind a successful backup strategy are universal. This checklist from TechRepublic Premium will help you establish a standard framework for backing up …
Artificial intelligence comes in many varieties, from tools that respond to customers via chat to complicated machine learning algorithms that predict the trajectory of an entire organization. Despite years of activity and the imaginative ideas found in science fiction, AI doesn’t yet comprise sentient machines that reason like humans. Rather, AI encompasses more narrowly focused …
Data governance is no longer a ‘nice-to-have’ measure in organizations as there is a growing concern around the globe that unregulated use of data can result in serious privacy violations, among other issues. That’s why data governance has topped the agenda in many continents as more efforts are being put in place to provide standards …
Get the web’s best business technology news, tutorials, reviews, trends, and analysis—in your inbox. Let’s start with the basics.
* – indicates required fields
Lost your password? Request a new password
Please enter your email adress. You will receive an email message with instructions on how to reset your password.
Check your email for a password reset link. If you didn’t receive an email don’t forgot to check your spam folder, otherwise contact support.
This will help us provide you with customized content.
Thanks for signing up! Keep an eye out for a confirmation email from our team. To ensure any newsletters you subscribed to hit your inbox, make sure to add [email protected] to your contacts list.
Leave a Reply