assign to key shortcut

How do I reassign hot keys for my keyboard?

You can reassign some keys to access different commands, shortcuts, or Microsoft Mouse and Keyboard Center features to better fit your work style.

Note:  The options listed in this wizard vary depending on the key selected. For example, since you cannot reassign the Windows key, the only option available is to disable it.

To reassign a key

Download and install the Microsoft Mouse and Keyboard Center .

Connect the keyboard that you want to configure.

Select the Start  button, and then select Microsoft Mouse and Keyboard Center .

From the displayed list of key names, select the key that you want to reassign.

In the command list of the key that you want to reassign, select a command.

Need more help?

Want more options.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Find solutions to common problems or get help from a support agent.

Online support

Was this information helpful?

Thank you for your feedback.

How to Create Keyboard Shortcuts in Windows 10

Any time you open a Windows app by rolling your mouse pointer over to an icon or lift your finger up and tapping on a tile, you're wasting time and putting unnecessary strain on your shoulder. The fastest and least physically-taxing way to launch any program is with a keyboard shortcut you can hit without even lifting your hands off of the homerow.   Windows 10 allows you to create custom shortcuts for any program, whether it's a traditional "desktop" app, a new-fangled "universal app" or one of Windows 8's "metro apps." Here's how.

Method 1: Create a Desktop Shortcut

1. Open a command prompt window.  You can get there by typing "cmd" into the Cortana / Search box and then right clicking on Command Prompt and selecting "Run as administrator."

2. Type "explorer shell:AppsFolder"  (without quotes) at the command prompt and hit Enter. A window with a list of all your apps appears.

3. Right click on an app and select Create shortcut. It may be easier to find your app if you change the view setting to "detailed list" so you can see all the icons in a single column.

4. Click Yes when asked if you want the shortcut on the desktop. A new shortcut icon appears on your desktop.

5. Right click on the new shortcut icon and select Properties.

6. Enter a key combination in the Shortcut key field. The combination must be CTRL + ALT + a letter / number.

7. Click OK.

Note:  Remember not to use the same key combination twice. Also note that some programs use CTRL + ALT + keyboard shortcuts that would also launch if you were in their windows. For example, in Photoshop Elements, CTRL + ALT + I brings up the resize menu.

Method 2: Use the Start Menu

If you're creating a keyboard shortcut for a "desktop app," any application that installs via direct download rather than Windows Store alone, you can create the shortcut directly from the Start Menu. By using this method, you can avoid creating a separate shortcut icon on the desktop.

1. Open the Start Menu.

2. Navigate to the icon or tile for the app you want. If the app is not pinned as a tile, you can find it by clicking on the All apps and scrolling through the alphabetical list.

3. Right click and select Open file location. A window opens with a shortcut icon. If Open file location doesn't appear on the menu, this is a modern or universal app and you'll have to follow method 1 above.

4. Right click on the shortcut icon and select Properties.

5. Enter a key combination in the "Shortcut key" box.  

6. Click OK.

Customize Windows 10

• Previous Tip
• Create Custom Keyboard Shortcuts
• Make Windows 10 Look and Feel Like Windows 7
• Change the Default Windows Font
• Turn Off Notification and System Sounds
• Change Your Desktop Background in Windows 10
• Change the Icon Size
• Give Windows 10 a Dark Theme
• Make Your Own Windows 10 Theme
• Hide Your Name on the Login Screen
• Add Another Column to the Start Menu
• Get Mac-Like File Previews
• Add My Computer Icon to Desktop
• Edit Photos to Fit as Backgrounds
• Add Accent Colors
• Customize Autoplay Menu
• Install and Delete Fonts
• Customize the Action Center
• Disable Transparency Effects
• Get Classic Solitaire and Minesweeper
• Change the Look of Windows 10 Books
• Add a URL Field to the Taskbar
• Add Clocks from Multiple Time Zones
• Get the Old Volume Control Back
• Disable Windows 10 Startup Delay
• Add Quick Contacts to the Start Menu
• Show Hidden Files and Folders
• Enable Spatial Sound
• Best Themes
• All Windows 10 Tips
• Change the Login Screen Background
• Install New Desktop Themes

Stay in the know with Laptop Mag

Get our in-depth reviews, helpful tips, great deals, and the biggest news stories delivered to your inbox.

Don't wait! B&H early Black Friday deal slashes $400 off this excellent Lenovo laptop

HP Envy x360 2-in-1 laptop gets $400 price cut in big early Best Buy Black Friday deal

Amazon Black Friday deals drop Nov. 17 — here's the 43 sales I recommend

Most Popular

By Hilda Scott 13 November 2023

By Sarah Chaney 12 November 2023

By Hilda Scott 11 November 2023

By Rami Tabari 11 November 2023

By Sarah Chaney 11 November 2023

By Ally Thomas 10 November 2023

By Sherri L. Smith 10 November 2023

By Hilda Scott 10 November 2023

By Sarah Chaney 10 November 2023

By Sean Riley 9 November 2023

• 2 How to get the iPhone 15 Pro, Apple TV 4K and Apple One all for FREE
• 3 Target Black Friday deals 2023: 7 best early sales to shop now
• 4 Amazon Black Friday deals drop Nov. 17 — here's the 43 sales I recommend
• 5 Amazon Black Friday Fire tablet sale takes up to 50% off

• Affordable Luxury: Top-Tier Tech Delights
• Early Black Friday Deals!

How to Create or Reassign Keyboard Shortcuts in Microsoft Office

Make commonly used tasks easier with custom hotkeys

In This Article

Jump to a Section

How to Customize Keyboard Shortcuts

• Creating 'Hotkeys'

Additional Tips

If you spend a lot of time in Microsoft Office or Microsoft 365 , you can save time by customizing your own keyboard shortcuts. Keyboard shortcuts are just one way to streamline how you work, but they can make a big difference, especially for tasks you use often. 

Shortcut assignments might vary depending on the operating system you're on and the software version you have installed.

Before looking at how to actually change a keyboard shortcut, let's open the appropriate window:

Open a Microsoft program, such as Word.

Navigate to File > Options  to open that program's options window, such as  Word Options  in MS Word.

Open the Customize Ribbon option from the left.

Choose the  Customize...  button on the bottom of that screen, next to Keyboard shortcuts: .

Creating 'Hotkeys'

The Customize Keyboard window is how you can control the hotkeys used in Microsoft Word (or whatever other program you've opened). Choose an option from the Categories: section and then pick an action for the hotkey in the Commands: area.

For example, maybe you want to change the shortcut key used to open a new document in Microsoft Word. Here's how:

Choose  File Tab  from the Categories: section.

Select  FileOpen  from the right pane, in the Commands: section.

One of the default shortcut keys ( Ctrl + F12 ) is shown here in the Current key: box, but next to it, in the Press new shortcut key: text box, is where you can define a new hotkey for this particular command.

Select that text box and then enter the shortcut you want to use. Instead of typing letters like Ctrl , just strike that key on your keyboard. In other words, hit the shortcut keys as if you were actually using them, and the program will auto-detect them and enter the appropriate text.

For example, hit the  Ctrl + Alt + Shift + O  keys if you want to use that new shortcut to open documents in Word.

You'll see a Currently assigned to: sentence show up under the Current keys: area after hitting the keys. If it says [unassigned] , then you're good to move on to the next step.

Otherwise, the shortcut key you entered is already assigned to a different command, which means that if you assign that same hotkey to this new command, the original command will no longer work with this shortcut. 

Choose  Assign  to make the new keyboard shortcut apply to the command you selected.

You can now close any open windows relating to the settings and options.

• You can remove custom and built-in keyboard shortcuts by returning to Step 4 in the first set of instructions above. In that  Customize Keyboard  window, just select a hotkey from the Current keys: box, and use the  Remove  button to delete it.
• Setting too many custom keyboard shortcuts can get confusing. Create them sparingly for those functions that do not already have a shortcut assigned to them. Reserve this method of reassigning or creating keyboard shortcuts for tasks that you use often.
• The quickest way to restore all the original shortcut keys is to return to the Customize Keyboard  screen mentioned above. Use the  Reset All...  button to reset all the hotkeys to their default, original settings.
• To view the program's default keyboard shortcuts in one simple place, select Help in the upper-right corner, and then select it again if you're using the Ribbon menu. Search for Shortcuts and find the program you're interested in, like Word, to see Microsoft's list of keyboard shortcuts.

Get the Latest Tech News Delivered Every Day

• The Best Windows Keyboard Shortcuts in 2023
• How to Use Windows Text to Speech Feature
• How to Disable a Keystroke Combination in Microsoft Word
• How to Create Macros in Microsoft Word
• How to Reset Keyboard Shortcuts in Word
• Adding Shortcut Keys to Word AutoText Entries
• 7 Ways to Open the Task Manager in Windows 11
• How to Use the GIMP Keyboard Shortcut Editor
• How to Turn On/Off Narrator in Windows 11
• How to Use Special Characters and Symbols in Word
• How to Screenshot on Microsoft Surface
• The Top 10 Most Frequently Used Microsoft Word Shortcuts
• 5 Ways to Go to the Desktop in Windows 11
• The Complete Apple Mail Keyboard Shortcut List
• How to Use Emoji Keyboard Shortcuts in Windows 11
• Use Keyboard Shortcuts to Speed up PowerPoint Presentations

By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts.

How-To Geek

How to remap any key or shortcut on windows 11.

Swapping all of the vowels on your friend's keyboard isn't an officially listed use, but...

Quick Links

Download powertoys from microsoft and install it, use powertoys to remap keys or shortcuts, alternative solution: remap keys in windows 11 using sharpkeys.

Microsoft PowerToys is a handy utility for Windows that lets you customize all sorts of things about Windows---everything from the behavior of windows on your screen to your keyboard shortcuts. Here's how you can use PowerToys to remap your favorite (or least favorite!) shortcuts.

PowerToys doesn't come preinstalled on Windows; you need to download it manually. Microsoft recommends that you download PowerToys directly from GitHub . You should grab the latest version --- it'll always be the one nearest to the top.

Related: What Is GitHub, and What Is It Used For?

Make sure that you grab the correct version for your PC. Most Windows desktops and laptops out there use 64-bit Intel or AMD processors, so download the installer that has "x64" in the name somewhere. Click the ".exe" file once it has finished downloading and follow the prompts.

ARM-based processors are gradually becoming more common in PC, so it is possible your have one. You can always see what CPU is in your PC , and then look up the model number to be sure. Alternatively, you can just guess --- if you try to install the wrong one, you won't hurt your computer, you'll just see an error message.

The other option is to install PowerToys from the Microsoft Store.  Just click "Install" and everything will be handled automatically. The only slight downside is that the version on the Microsoft Store is updated a bit more slowly than the version on GitHub, so you'll have to wait a bit longer for bug fixes.

If you want you can install PowerToys via a command line as well. Open up Terminal, make sure it is a PowerShell tab, then copy and paste 

into the window and hit Enter.

Launch PowerToys and click on "Keyboard Manager" on the left-hand side.

Ensure that "Enable Keyboard Manager" is toggled to the "On" position --- it should be by default. There are two choices: "Remap a Key" and "Remap a Shortcut."

The names mostly speak for themselves. "Remap a Key" lets you map a key to a different key, a key to a shortcut, or a key to a function.

Related: Windows Task Manager: The Complete Guide

As a silly example, you could use "Remap a Key" to map the "T" key to "Ctrl+V" so that pressing "T" would trigger the paste function. You could map the "[" and "]" keys to "Volume Down" and "Volume Up," respectively.

You can select a key, shortcut, or function, using the drop-down menus, or you can click "Type." If you click "Type," you just need to press the key you want instead of scrolling through the list.

You're mostly constrained by the fact that there aren't many keys on your keyboard that can reasonably be rebound to other keys, shortcuts , or functions without impinging your ability to use your computer normally.

"Remap a Shortcut" is more useful in that regard. Unlike "Remap a Key," "Remap a Shortcut" allows you to combine multiple keystrokes and map them to another shortcut or function, and you can even make the remapping application specific. That gives you a ton of flexibility and lets you work around almost any preexisting shortcuts that might cause a conflict.

Related: 30 Essential Windows Key Keyboard Shortcuts for Windows 10

Select your new key combination, select the shortcut or function you want to map the new key combination to, and then pick the application you want to use it with.

Leave "Target App" blank to make the remap system-wide. If you want a remap to apply only to a specific program, you need to enter the program's executable name into the box.

You can open Terminal and enter the command "tasklist" to get a list of the processes currently running. It will display the name you need to enter into the "Target App" box under the "Image Name" column.

Now instead of mapping "[" and "]" to "Volume Down" and "Volume Up," you can map "Ctrl+[" to "Volume Down" and "Ctrl+]" to "Volume Up," and you don't need to worry about messing with your ability to insert brackets or curly brackets at all. If you wanted, you could map "Ctrl(Left)+Shift(Right)+T" to "Delete" and make it only apply in GIMP.

Plenty of applications let you remap shortcuts or functions within their settings, but some don't --- they're ideal candidates for the PowerToys remapping utility. Microsoft specifically warns that it may not work well in games , though, so test it thoroughly before you join a competitive match.

The one drawback to using PowerToys is that the utility needs to be running if you want to keep the key remapping working. Windows actually supports built-in key remapping via the Registry, but it's so complicated that you're better off using the open source SharpKeys application to handle it.

SharpKeys will allow you to remap any key to any other key, on any version of Windows, and you can even delete the application when you're done. The limitation? It can't handle shortcut key combinations, so you couldn't remap ALT+C to CTRL+C, but you can use it for things like disabling or remapping the Caps Lock key .

Simply install the application from the Microsoft Store or their Github repository, launch it, and then you can click the Add button from the interface to bring up the Add New Key Remapping dialog. From there, you can map from one key to another easily.

SharpKeys has worked in every version of Windows since at least Vista, so you can definitely use it for remapping keys on Windows 10 as well .

How to create a Windows shortcut key

Windows shortcut keys are a powerful, highly configurable tool that allow you to access frequently-used shortcuts using a key combination on your keyboard.

Create a shortcut for a program or file

• Open the folder or directory containing the program or file you want as a shortcut.
• Right-click the program/file and select Create Shortcut .
• Once done, this creates a shortcut named "Shortcut to <your program/file>" or "<your program/file> - Shortcut" in the current directory . To rename this shortcut, right-click the file and select Rename .
• Once the steps above are completed, copy or cut this shortcut and paste it anywhere.

Assign a shortcut key to that Windows shortcut

Once the shortcut is created, to assign a shortcut key to that Windows shortcut, follow the steps below.

• Right-click the shortcut and select Properties .
• Click the Shortcut tab.
• Click in the Shortcut key box and press a letter. For example, if you press P , the key combination to run this shortcut is Ctrl + Alt + P .

How to create a shortcut key that performs a function

The steps above are great for those who want to create a shortcut key to open a commonly used program. However, what if you want to create a shortcut key that performs a specific function in a program? Some more advanced programs allow you to assign keyboard shortcuts in the program. For example, in Adobe Dreamweaver , click Edit and then Keyboard Shortcuts to define the keys you want to use for a shortcut.

Unfortunately, most programs do not offer this level of customization. If you're using Microsoft Windows, you can install AutoHotkey to create scripts that can be assigned to any shortcut key.

Related information

• How to create a Windows shortcut.
• Create a shortcut key for Internet web pages.
• Microsoft Windows help and support.

Create Custom Keyboard Shortcuts for Anything in Windows 10

Speed up your workflow and get rid of repetitive tasks

Want to know how to create keyboard shortcuts to do anything on Windows 10? This guide will help. Surprisingly, it’s quite easy to create a quick keybind that can open programs, perform repeatable tasks, and speed up your workflow.

I’ll suggest a number of different options you can use to make keyboard shortcuts and provide some examples of how you can use them to their max potential.

Open Programs Quickly

I can see this shortcut option being useful for a large number of Windows 10 users. It’s quick and easy to set it up so that a quick shortcut can open any executable file. Here’s how to do it.

First, download the WinHotKey program from Directedge . It’s free to use. It’s a bit old, but it works and it’s clean. Once downloaded, go through the installer wizard, then launch WinHotKey. In WinHotKey, click New HotKey in the top left.

In the new window that appears, give the hotkey a name . After, choose what combination you’d like to trigger the shortcut. For example, I chose to do Windows+F2. After, you can click the Browse option to find the location of the executable you’d like to open.

Alternatively, you can just copy and paste the location. WinHotKey will automatically grab the application icon so that you are given visual context about it. You can now open your program with the hotkey you’ve specified.

You must make sure that your keyboard shortcut doesn’t conflict with any existing shortcuts, either Windows defaults or from within the WinHotKey interface. For example, Alt+F4 couldn’t be used. It’s best to stick to Windows + ’X’ combinations to avoid conflicts.

Automatically Type Text

If you consistently type the same sentences or words, you can automate it with WinHotKey too. To do this, click New Hotkey in WinHotKey, then click the drop down box under I want WinHotKey to: and select Type some text .

Now, type or paste the text into the box at the bottom of the new hotkey window. Finally, make sure to choose a new keyboard shortcut you haven’t used before.

There isn’t a limit on how many characters you use with this shortcut, but if there is a line break in anything you paste, it will end there. So, it’s best for copying single paragraphs, things like hashtags for Instagram or social links for YouTube descriptions.

Open Folders and Documents in Windows 10

WinHotKey can also be used to quickly open specific folders and documents within Windows 10. You can simply select the Open a Document or Open a Folder options under the I want WinHotKey to: dropdown box and then follow the same steps as above.

This time though, you’ll need to browse to a specific file or application. If you choose the open document option, most documents will work, so long as you have a supporting application defaulted to open those kinds of files. From my testing, I could get Photoshop, office apps like Excel, PDF files, and text files.

If a file didn’t work, Windows 10 will ask you to choose a default application for that file type, and then future hotkeys with that file type would then also work.

Use Autohotkey for Emojis

AutoHotkey is another application for Windows 10 that can help you to create more complex keyboard shortcuts. This software can be used to automate a large number of different tasks. You can download Autohotkey from their website for free.

Once you’ve downloaded it, extract the file to a memorable location. Then, in the directory, double click an .ahk file , then when asked, choose to browse what application should be used to open such files. Next, browse and navigate to AutoHotkeyU64 . This will allow you to run AutoHotkey scripts by double clicking them.

It’s very easy to use emojis on a smartphone, but there isn’t any easy way to do this on a computer by default. With Autohotkey, you can set up a number of emoji shortcuts. Here’s how to do it.

Creating a hotkey extension can be quite complex, but thankfully there are dozens of great autohotkey scripts on the internet. For creating emojis, we’d suggest this one .

On the page shared above, click the Raw button to be taken to a raw text file. Next, press Ctrl+A to select the entire code. Then press Ctrl+C to copy it all. After, open a Notepad file and paste the code there.

Now, click File in Notepad, then click Save as . Navigate to the directory you extracted Autohotkey. Next, click the Save as type drop down box and select All files. Now, name it Emoji.ahk and click Save.

To use this hotkey script, you’ll need to double click it each time you start your PC . After, you can type emoji codes like :smiley: to automatically use emojis. At any time, you can refer back to the Github link above to see which codes are used for each emoji.

More Advanced Autohotkey Scripts

The potential for more advanced Autohotkey scripts is quite impressive. You can read up on some of the best scripts here .  Some examples include the following:

• Magnify the screen with keybinds
• Use mouse gestures
• Drag windows easily
• Quickly access your favorite folders
• View upload/download speed via a small on-screen overlay

I hope that this guide on using Windows keyboard shortcuts has been useful. Did you learn anything? I hope so. Did you struggle with any of the suggestions in this guide? If so, send me a Tweet and I’ll be happy to help out as soon as possible.

Ollie stumbled upon writing online whilst participating in a mobile network forum back in 2011. Since then, he has developed an incredible passion for writing about all sorts of tech from smartphones, PC hardware, software, and everything in between. Read Ollie's Full Bio

Read More Posts:

Leave a Reply

Your email address will not be published. Required fields are marked *

April 11, 2023

Share this page

Remapping 101: How to change your keyboard key output

Your PC or laptop keyboard doesn’t have to be one-size-fits-all. If you’re not a fan of certain key placements or find that you aren’t using some of your keys, you can rearrange the functions of your keys however you like. Most keyboards are laid out in the same way, but Windows 11 features  allow you to make the necessary adjustments to help you type more comfortably. Learn how you can remap your keys and change keyboard outputs on Windows 11 .

Why remap your keyboard?

If you’re used to a standard keyboard layout, you may not initially see the value in remapping your keys. Here are some common reasons for changing keyboard outputs:

• Typing on a foreign keyboard. If you want to type in any language besides English, it can be difficult to type seamlessly on an English-only keyboard. By switching your key functions, you can cater to different language settings.
• Using your keyboard for PC gaming. PC gamers rely on their keyboards to play their favorite games. Remapping your keys to best suit your gaming needs can improve performance and make your frequently used keys more accessible.
• Repurposing underused keys. Not everyone uses their keys the same way. If it seems like a key that you don’t often use is taking up valuable space on your keyboard, you can reassign its function to find a good use for it and increase productivity.

Popular QWERTY alternatives

You may notice that top row of letters on your keyboard, going left to right, spells QWERTY. However, there are other popular keyboard layouts that can help you type faster or more comfortably. Learn more about each layout and how they might benefit your typing:

• AZERTY. The AZERTY layout simply moves the output of the Q , W , and M keys. It is most often used in France and other surrounding countries.
• Dvorak. The Dvorak layout puts the most used keys in the middle row, which decreases finger movement. This typing method can help reduce strain in your fingers, which makes for a more ergonomic experience.
• Colemak. The Colemak layout offers a slight improvement on the Dvorak layout. It also places the commonly used keys in the middle row, but it keeps the useable features of the QWERTY layout intact.

How to remap your keys on Windows 11

The easiest way to change your keyboard functions on Windows 11 is to use the Keyboard Manager  utility. The Keyboard Manager is one of many utilities available in Microsoft PowerToys , which are a collection of productivity tools that allow users to customize their Windows experience.

How does Keyboard Manager work?

Once you’ve downloaded PowerToys onto your device, select Keyboard Manager and toggle Enable Keyboard Manager. You’ll find separate sections for remapping keys and remapping shortcuts, each of which can be adjusted to your liking. Some keys and shortcuts cannot be remapped in Keyboard Manager, and these limitations are highlighted on the platform. PowerToys must be running for the key mapping to work, so make sure you don’t close out of the program after making your selections.

What other keyboard mapping functions are available on Windows?

If you are still running Windows 10 on your PC, you can download Microsoft Keyboard Layout Creator  to create your own keyboard layouts. Microsoft keyboard users can also try the Mouse and Keyboard Center  app to get the most out of the customization features within the accessories. Other keyboard mapping options can be downloaded on Microsoft Apps .

By learning how to remap your keys, you can break the mold and take control of how you use your keyboard. Shop for Microsoft Keyboards  to find the perfect keyboard to test your remapped keys on Windows 11 .

Products featured in this article

More articles

How to check your GPU and why it matters

Get to know the purpose and value of your computer’s GPU.

How to use Windows Remote Desktop to access a PC

Learn how Windows Remote Desktop allows you to access your PC from anywhere.

How to find and enjoy your computer's accessibility settings

Find the features to help with specific vision, hearing, or mobility needs.

Stack Exchange Network

Stack Exchange network consists of 183 Q&A communities including Stack Overflow , the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

how do I create word/sentence keyboard shortcuts

Is there a way to create either word or sentence (or both) keyboard shortcuts so that when you want to type a word, you can just do the shortcut and it pastes it into wherever you're typing? The idea is to be able to have shortcuts to paste boilerplate words or sentences into whatever application I'm typing in.

For example, my dad has trouble typing and say he typically types the word "photos" a lot. Is there a way to make it so that when he wants to type "photos", he can just do like Ctrl+P or some other shortcut so that "photos" is pasted into wherever he is typing?

This is not a question about MS Word or any text editing application, just in general. But if there are ways to customize MS Word or other apps, it would be nice to know how to do it :)

• keyboard-shortcuts

• 2 Look at the top answer for this question: superuser.com/questions/29254/automate-gui-tasks –  Oliver Salzburg Feb 17, 2012 at 22:44

As Oliver implied, you can use AutoHotkey . Creating keyboard shortcuts and sending keystrokes are of the most basic functions of AHK. So, assigning Ctrl + P to photos is as simple as:

Which translates to:

If P is pressed while Ctrl is down, simulate the following keystrokes: p , h , o , t , o , and s .

Note that you can send uppercase letters without explicitly sending a preceding Shift key:

is equivalent to

You must log in to answer this question.

Not the answer you're looking for browse other questions tagged keyboard-shortcuts ..

• The Overflow Blog
• CEO update: Giving thanks and building upon our product & engineering foundation
• The AI assistant trained on your company’s data
• Featured on Meta
• Update: New Colors Launched
• Incident update and uptime reporting

Hot Network Questions

• No space left in device - Empty USB drive
• What's going on with the bonkers derailleur?
• How does wealth corrupt someone?
• Can I apply for a UK tourist visa if I overstayed a Schengen visa 11 years ago?
• Will the passport control (tourist visa check) happen in Norway (destination and visa issuing country) or Munich (layover)?
• Minimum Races for Top 3 horses
• Behavior of BJT collector current in saturation
• Why should I route the feedback trace under the output capacitor?
• How can I hide a part of an reflection in Cycles
• Inkscape - how to (re)name symbols in 1.3?
• Difference of two polyline layers in QGIS
• Why do we add an 'um' here?
• Is it possible to say Ändern des Namens?
• Will recording as MIDI lose the quality of a WAV?
• ARGV[] not accepting the argument
• Could the human body feel the sudden disappearance or end of a gravitational force?
• Best practices for reverting others' work (commits) and the 'why' for it?
• Do I need to let the editor know of my first peer-review?
• a Gutter or Sewer?
• Paying $185k back rent to sister - can I claim in taxes?
• Does n have to equal infinity?
• Melted electrical outlet
• Divergence, interior products and Lie derivative coincide?
• Talking about ロサン and ウサン

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy .

How to change keyboard shortcuts in Windows 11

Change keyboard shortcuts in Windows if the default ones don't work for you

You'll want to know how to change keyboard shortcuts in Windows 11 if the default shortcuts just aren't cutting it for you. 

Perhaps you're used to a macOS keyboard, or switch between Windows and Mac for work/play like me — if that's the case, it's super useful to reconfigure the default Windows shortcuts so that they're the same as on Mac. You might also want to use a particular keyboard shortcut that feels more comfortable, if you have difficulties with your hand or finger movement, for example.

Whatever the reason, it's easy to change keyboard shortcuts in Windows 11, but it isn't obvious how to do so if you don't already know. Luckily, this guide is here to walk you through it.

To remap the default Windows keyboard shortcuts, we're going to be using the PowerToys (a suite of Windows tools for power users) Keyboard Manager. Read our guide on how to get PowerToys in Windows 11 if you haven't got the tools yet.

We've already covered how to remap keys in Windows using the Keyboard Manager, but the process for remapping shortcuts is a little different. Remapping keys also changes individual keystrokes, while remapping shortcuts changes keystroke combinations like Ctrl + C (copy). You can also remap specific shortcuts to work differently in specific apps, which we'll also cover in this guide.

If you're ready to get into the guide, so are we! All you need to do now is read on to find out how to change keyboard shortcuts in Windows 11.

Before you start: remap shortcuts with a little bit of caution as it can cause headaches down the line, but don't worry about messing things up permanently. You can always undo the remaps that you apply with a simple click of the trash can in Keyboard Manager.

1. Open PowerToys and enable Keyboard Manager

First up, open PowerToys and select Keyboard Managers from the menu on the left. It should be on by default, but if it isn't, toggle on Keyboard Manager .

2. Select Remap a shortcut

Now select Remap a shortcut .

3. Click the + button

Click the + button to create a new shortcut map. 

4. Select your Physical Shortcut

You now need to select your Physical Shortcut . This is what keys you press in order to get the result of the existing shortcut you don't like. For example: I am going to set Ctrl + Up Arrow as my Physical Shortcut, mapped to Ctrl + C. That means when I press Ctrl + Up, I will get Ctrl + C (copy).

You have two options to select your Physical Shortcut. Click the dropdown and select a shortcut , or click Type and press the keys you want .

5. Choose your Mapped To keys

Now choose your Mapped To keys in the same way as step 4. As you can see in the screenshot, I have select Ctrl + Up as my Physical Shortcut and Ctrl + C as my Mapped To.

If you're typing your shortcuts as in the screenshot above, press OK when the correct keys appear.

6. (Optional) Select an app to use the new shortcut

You can now select a target app for the shortcut to work in. In the example above, I have selected only Microsoft Word for this shortcut to run in. You need to use the .exe name of the application : for word that's WinWord. Essentially use everything before the ".exe" on the application executable filename .

To use the shortcut globally, simply leave the Target Apps box blank .

7. Click OK when done

When you're happy, click OK to save your changes.

Don't worry if you don't like your new shortcut. To delete a shortcut, simply follow steps 1-2 to return to the Remap shortcuts page and click the trash can icon next to the shortcut you want to delete .

It's as easy as that! You can now create all the shortcuts you like. If you'd like to read more ways to use PowerToys, we can show you how to use PowerRename to bulk rename files and how to keep your computer awake with PowerToys Awake . You might also be interested in learning about how to customize the Windows 11 Start menu , if you aren't a fan of how it looks or works.

Get Black Friday deals in your inbox!

Instant access to the hottest deals available plus daily breaking news, reviews, helpful tips and more from the Tom's Guide team.

Peter is Editor of the How To and Camera sections at Tom's Guide. As a writer, he covers topics including tech, photography, gaming, hardware, motoring and food & drink. Outside of work, he's an avid photographer, specialising in architectural and portrait photography. When he's not snapping away on his beloved Fujifilm camera, he can usually be found telling everyone about his greyhounds, obsessively detailing his car, squeezing as many FPS as possible out of PC games, and perfecting his espresso shots. 

I use this pedal to control my PC hands-free — and it just hit lowest price ever for Black Friday

Windows 11 just became an app for your iPhone — here's how it works

7 best Thanksgiving movies to stream with the whole family

Most Popular

By Rachael Phillips November 15, 2023

By Cynthia Lawrence November 14, 2023

By David Crookes November 14, 2023

By Madeleine Streets November 13, 2023

By Richard Priday November 13, 2023

By Sam Hopes November 12, 2023

By Peter Wolinski November 12, 2023

By Jackie Dove November 11, 2023

By Peter Wolinski November 11, 2023

By David Crookes November 10, 2023

How to Set Up Your Own Keyboard Shortcuts in Windows 11

Fancy adding some keyboard shortcuts of your own to Windows 11? Here's how to do it.

Windows 11 includes numerous keyboard shortcuts right out of the box. However, the operating system doesn’t include any options for creating custom hotkeys that open software, documents, and folders. You can still add hotkeys to desktop shortcuts, but adding a plethora of shortcuts to the desktop isn’t exactly an ideal way to set up your system.

As a result, it’s better to check out some of the third-party keyboard shortcut software packages for Windows 11. WinHotKey and HotkeyP are among those apps that enable you to set up keyboard shortcuts for your favorite software, documents, and folders. This is how you can set up custom hotkeys with WinHotKey and HotkeyP.

How to Download and Install WinHotKey

WinHotKey is a freely available app for setting up new keyboard shortcuts. That software is compatible with most Windows desktop platforms as well. It has a quick and easy setup and takes up very little drive storage space. You can download and install WinHotKey as follows.

• Open WinHotKey’s Softpedia page in a web browser.
• Select the Download Now option.
• Click the Softpedia Secure Download (US) option and download the file.
• Select the Next option.
• Click the I accept the agreement radio button, and press the Next button again.
• Select the Next option to install the software.
• After installing, select the option to set up a WinHotKey desktop shortcut. Then you can click that shortcut to launch the software.

How to Set Up Software Hotkeys

The WinHotKey Configuration includes a list of default Windows hotkeys . However, you can’t edit those default keyboard shortcuts in any way. What you can do is add new custom hotkeys for opening software to that list. You can set up new custom keyboard shortcuts for launching software like this.

• Type an optional description for the hotkey in the text box on the General tab if you wish.
• Select the Launch an application option on the drop-down menu.
• Select an app for the hotkey to launch.
• Click the OK button.
• You can also select additional keys for the hotkey by clicking the Alt , Shift , and Ctrl checkboxes. The Windows checkbox is selected by default, but you can deselect that option.
• Click the OK button to exit the Launch: Advanced window.
• Then press the OK button on the New Hotkey window to add the keyboard shortcut.

Thereafter, the WinHotKey Configuration window will include your custom hotkey.

Now you can press your new hotkey to open whatever software you selected for it. You can change that keyboard shortcut by selecting it and clicking Edit Hotkey . To delete one, select it and click Remove Hotkey .

You can set up hotkeys for launching Windows programs as well as third-party software. The C: > Windows > System32 folder path includes many of the built-in accessories. These are some of the Windows features you can set up hotkeys for with WinHotKey:

• Control Panel: control.exe
• Task Manager: Taskmgr.exe
• Calculator: calc.exe
• Command Prompt: cmd
• Notepad: notepad.exe
• Performance Monitor: perfmon.exe
• Registry Editor: regedit.exe
• Event Viewer: eventvwr
• Services Windows: services.msc
• Optimize Drives: dfrgui

How to Set Up Folder, Document, and Window Control Hotkeys

Aside from software shortcuts, you can establish hotkeys for opening folders and document files much the same. Instead of selecting Launch an Application on the New Hotkey window, select either the Open a Folder or Open a Document option. Then click Browse to select a document’s or folder’s path, configure a key combination, and press the OK button.

WinHotKey also enables you to set up hotkeys for six different window control actions. To set up such a keyboard shortcut, select the Control the Current Window option on the New Hotkey window. Then you can select minimize, maximize, restore, toggle, resize, and move window control options for the keyboard shortcut.

How to Create Custom Keyboard Shortcuts With HotkeyP

HotkeyP is a decent alternative third-party app to WinHotKey for creating custom Windows keyboard shortcuts. Like WinHotKey, it’s a freely available and lightweight app for utilizing on most Windows platforms. It enables you to set up custom keyboard shortcuts for opening user files and folders, running programs, and activating many functions. This is how you can download and run HotkeyP:

• Bring up the HotkeyP Softpedia page .
• Click HotkeyP’s Free Download button.
• Double-click HotkeyP.exe file inside the extracted hotkeyp_64bit directory.

Now you’ll see an empty HotkeyP window. You can fill that window by adding some new custom hotkeys. First, try setting up a hotkey that opens software on your PC like this:

• Press the … (ellipses) button for the Command box.
• Select a program’s EXE (application) file for the hotkey to open.
• Then click inside the empty box beside those checkboxes and press a key on your keyboard to include it within the hotkey.
• Select OK to add the new custom hotkey.
• Now you’ll see the new hotkey you’ve created included within the all and programs categories on the HotkeyP window. Press the new hotkey you just set up to launch the selected program.

There are extra options you can select to configure how the hotkey launches the program. For example, select Run as administrator to set the program to open with elevated privileges. Or set the software to run at a higher priority by selecting a high or above normal option on the Process priority drop-down menu.

You can set up custom hotkeys that open user files and folders much the same. To do so, click the … button in the Hot Key window and select a user file or folder instead of an app. Set the keyboard shortcut with the other settings.

To set up some system, multimedia, window, and display hotkeys with HotkeyP, click the < button on the Hot Key window. Move your cursor over the Windows , Display , Multimedia , or System submenu. Select a function (or action) to assign to the hotkey. For example, you can set up a hotkey that shuts down Windows by selecting Shutdown on the System menu.

You can change general software settings for HotkeyP by clicking the Options button. That will bring up an Options window that includes numerous miscellaneous software. Make sure the Start automatically at Windows startup checkbox is selected on the General tab. Then HotKeyP will automatically start in the background.

Set Up All the Windows Software HotKeys You Need With WinHotKey

So, you won’t need Windows 11 desktop, Start menu, and taskbar shortcuts anymore when you’ve got WinHotKey or HotKey P. They're easy-to-utilize programs with which you can set up a wide variety of software, folders, and document keyboard shortcuts without cluttering the Windows desktop. Their only notable shortcoming is that you can’t set up website hotkeys with them, but they're still very handy apps nonetheless.

Special offer: Complimentary Access to PopSci+ for a limited time »

Become a Windows whiz by creating your own keyboard shortcuts

May we present: the keys to productivity.

By David Nield | Published Nov 12, 2020 3:42 PM EST

Knowing the right keyboard shortcuts can make a big difference in how quickly you can get stuff done—and if the hotkeys you need aren’t available, it’s not difficult to create your own.

Whether you need to launch a specific application regularly, have a folder you need quick access to, or want to enable a particular tool, you can set up a keyboard combination to help.

But before you start experimenting with new Windows shortcuts, it’s a good idea to learn the ones that already exist. You might find that what you’re looking for is already available, but you’ll also ensure your new combos don’t duplicate those that are already set up.

We’ve previously covered some of our favorite picks , from Win+D to show or hide the desktop to Ctrl+W to close windows and tabs, but Microsoft also has a comprehensive list of shortcuts for you to refer to.

Feel like an expert now? Good. It’s time to make your own.

Create keyboard shortcuts with Windows

Building a new keyboard shortcut to a program, file, or folder in Windows is easy. In File Explorer, right-click on whatever you want to open with your keyboard combination, and choose Create shortcut .

A new icon will appear, which is the shortcut to the program, file, or folder—it’s not a keyboard shortcut yet. It’s the sort of shortcut you’d find on your desktop, linked to an application or a folder deeper within the operating system. Double-clicking this new icon will open up whatever you’ve linked to.

The trick is that this newly created shortcut can be assigned a shortcut key as well. Right-click on it and choose Properties , then Shortcut . Click in the box marked Shortcut key , then press your choice of keys to assign them (they should appear in the box). Click OK to confirm your choice.

Pressing your new combination of keys will launch whatever file, folder, or program you selected, saving you a trip to the Start menu or the taskbar.

You need to be careful not to duplicate other key combinations from Windows, or the apps you use, as you won’t get a warning if there’s a duplicate—it’ll just do what it was originally assigned to do. You’ll also need to use a couple of modifier keys (Shift, Ctrl, or Alt) in your combination to tell Windows that you want to activate a shortcut—you can’t just hit “s” and have Spotify launch itself, for example.

Create keyboard shortcuts with third-party programs

A handful of third-party programs will help you create custom keyboard shortcuts for Windows. WinHotKey is an older one, but it’s easy to use, still works fine on Windows 10, and won’t cost you anything.

With the program loaded on screen, click New Hotkey to configure your new shortcut. The next screen will let you specify a key combination—which must include Shift, Alt, Ctrl, or the Windows key—and then associate an action with it. Each shortcut can open a file or a folder, or launch a program.

AutoHotKey is a newer, more advanced shortcut creator, and it’s also free to use. It requires a bit more investment in terms of time and thought, but it lets you create more complex shortcuts for typing out fragments of text (like typing “tks” to tell someone “thanks a lot,”) and putting messages on screen (like a dialog box with the date), as well as launching specific apps, files, and folders.

You’ll need to create scripts by right-clicking on the desktop and choosing New , then AutoHotKey Script . These contain the code necessary for your shortcuts to work on Windows in response to your key presses, like making sure the “run” command launches programs and the “send” command types text.

Don’t worry if this sounds overwhelming—when you use AutoHotKey for the first time, you’ll be met with a brief tutorial that will guide you through some basic scripts. All the documentation you’ll need is also available online .

It doesn’t take long to grasp the basics, and once you do, you’ll be able to conduct a whole host of actions with just your fingers and keys.

Create keyboard shortcuts from inside your applications

You can add even more personalized keyboard shortcuts within many of the applications you use regularly. This option won’t be available in every program, but quite a few apps offer it, so it’s worth checking.

Microsoft Word, for example, includes the feature. With a document open in Word, choose File , Options , Customize Ribbon , and then Customize (next to “Keyboard shortcuts”) to start adding new ones. Use the Save changes in box to keep new shortcuts specific to a document or template, or just leave the default Normal.dotm value there to apply your changes to all future documents based on the default template.

You’ll see a list of commands available in Word, and creating keyboard shortcuts for them is as simple as selecting them from the list and hitting your preferred combination of keys. If the shortcut is already linked to a command, Word will tell you with a popup dialog box that also lets you disable existing shortcuts and add new ones.

Adobe Photoshop is another program that lets you customize keyboard shortcuts. Open the Edit menu and choose Keyboard Shortcuts to get started, or make use of the keyboard shortcut for the Keyboard Shortcuts dialog—it’s Alt+Shift+Ctrl+K .

You can set shortcuts for menu items, opening panels in the interface, and switching to specific tools—just select one of these entries in the list on screen, then click Add Shortcut , and press your chosen key combination. If you pick a shortcut that already exists, Photoshop will warn you (and switch the shortcut, if you want it to).

David Nield is a freelance contributor at Popular Science, producing how to guides and explainers for the DIY section on everything from improving your smartphone photos to boosting the security of your laptop. He doesn't get much spare time, but when he does he spends it watching obscure movies and taking long walks in the countryside.

Like science, tech, and DIY projects?

Sign up to receive Popular Science's emails and get the highlights.

List of all Windows 10 keyboard shortcuts: The ultimate guide

Windows 10 includes many keyboard shortcuts to make your experience around the desktop easier, and you can check them out here.

Windows 10 includes a long list of keyboard shortcuts you can use to quickly navigate and perform actions using one or multiple key combos, which otherwise would take many more clicks and time to complete the task with the mouse.

The system has many shortcuts, but you don't need to learn every shortcut on Windows 10 . You only need to remember those that can help you make your workflow easier.

In this how-to guide , I'll outline all the most helpful keyboard shortcuts to navigate and operate the desktop and apps. You can also check out these additional shortcuts you need to know for Windows 11.

Windows 10 keyboard shortcuts

This comprehensive list includes the most helpful keyboard shortcuts to perform tasks on Windows 10.

Essential shortcuts

In this list I'm including the most essential keyboard shortcuts you should know on Windows 10:

Desktop shortcuts

On Windows 10, you can use these keyboard shortcuts to open, close, navigate, and perform tasks more quickly throughout the desktop experience, including the Start menu, Taskbar, Settings, and more.

File Explorer shortcuts

These are the most useful keyboard shortcuts you can use on File Explorer:

Settings page shortcuts

This list includes the keyboard shortcuts for the dialog box legacy settings pages (for example, Folder Options).

Command Prompt shortcuts

On Command Prompt, you can use these keyboard shortcuts will help to work a little more efficiently:

Microsoft Edge shortcuts

On Microsoft Edge, you will benefit from these keyboard shortcuts. These shortcuts apply to any version of Windows.

Windows key shortcuts

The "Windows key," combined with other keys, allows you to perform many useful tasks, such as launch Settings, File Explorer, Run command, apps pinned in the Taskbar, or open specific features like Narrator or Magnifier. You can also complete tasks like controlling windows and virtual desktops, taking screenshots, locking the computer, and more.

This list includes all the most common keyboard shortcuts using the Windows key.

More resources

For more helpful articles, coverage, and answers to common questions about Windows 10 and Windows 11, visit the following resources:

• Windows 11 on Windows Central — All you need to know
• Windows 10 on Windows Central — All you need to know

Get the Windows Central Newsletter

All the latest news, reviews, and guides for Windows and Xbox diehards.

Mauro Huculak is technical writer for WindowsCentral.com. His primary focus is to write comprehensive how-tos to help users get the most out of Windows 10 and its many related technologies. He has an IT background with professional certifications from Microsoft, Cisco, and CompTIA, and he's a recognized member of the Microsoft MVP community.

• 2 "We are getting very good at identifying a Russian campaign," Microsoft weighs in on disinformation and national security at recent events
• 3 The custom Bluey Xbox Series X looks amazing and will be going to one lucky winner
• 4 "We don’t allow ads on our platform that contain sexually explicit content," Google explains after an explicit ad surfaced on YouTube amid its firm stance on ad-blockers
• 5 How to use Copilot to find products on Microsoft Shopping quickly

Are there some way to assign keyboard shortcut to Dolphin's Context Menu?

Can you help me, please?

I really would like to invoke the Dolphin’s Context Menu with keyboard shortcut “Shift + F10” , but there aren’t input to set this in “ Configure Keyboard Shortcut… ” menu.

I found out some way using xdotool to emulate the mouse’s right click any key of the keyboard, but I would prefer other way, if it is possible.

So… Do somebody know how can I configure this?

Operating System: KDE neon 5.27 KDE Plasma Version: 5.27.9 KDE Frameworks Version: 5.111.0 Qt Version: 5.15.11 Kernel Version: 6.2.0-36-generic (64-bit) Graphics Platform: X11

I have always just used the Menu key between the right Alt and Ctl keys. Does your keyboard not have this?

Maybe I am not reading your post correctly.

I think OP is asking about the hamburger menu.

OP wants an alternative method to xdotool.

I’ve attempted 2 ways with 0 success.

In Dolphin.

Configure > Configure keyboard shortcuts > Open Menu > Assign Custom shortcut

Didn’t work for me.

qdbus org.kde.dolphin-20200 /dolphin/Dolphin_1/actions/hamburger_menu trigger

OP is on x11, xdotool works. If his xdotool menu works, he’s asking, like he stated, for the context menu. I’m guessing his keyboard doesn’t have a menu button. My bad, misread the post. He already used an xdotool command. Then again, if a menu button works I provided him with a shortcut alternative. No idea if he’s using that one really.

Ignore that, I didn’t read: “Context Menu”

Maybe the OP will respond soon and give us something else to go on.

WilsonEPhillips, I don’t have this key on my keyboard…

dzon and GoldBarb, I would like to use other alternative instead of xdotool …

My problem has been that I don’t have some functions without access the context menu, like the “Open Path”, when perform search for files and folders.

I really miss this feature, coming from others files explorer, like Windows Explorer .

I thought for sure there would be an option in System Settings > Input Devices > Keyboard > Advanced, but nothing for the Menu key.

I’m completely lost . There is a shortcut for “open path” sooo… I don’t understand why you need a shortcut for an entry in a context menu which has a shortcut to begin with? If it’s about specific functions I guess you could make a bash script and assign shortcuts to those. I’m at a loss here. If it’s purely an overall function to find files one doesn’t need a contextmenu, there are other tools for that.

I did find this on the Arch forum. This lets us know what the key press would be if you had the key.

Xev: keycode 135 (keysym 0xff67, Menu)

Sorry, I couldn’t explain very well my reason…

I want the context menu because this show some functions that isn’t in no place else. Also, It show some usual function in a single panel from different upper menu bar category.

I have only one key to Ctrl", “Alt”, “AltGr” and “Super”. So, I can’t overwrite one of these key to “Menu” key without lost one of them.

My point was what the key would do if you had the key. This would be what Alt+F10 needs to perform. In Windows, this is the default for Alt+F10, but not on Plasma.

Okay. If you want that alternative to a missing menu key, do the following: 1)system settings>shortcuts 2)Custom shortcuts>add a new action 3)Set your key combo under Trigger and name it Menu under Action 4)Apply

And um…I hope you don’t think you can get the dolphin context menu allover the place. That’s for dolphin and its’ servicemenus.

Thanks to dzon and this answer post from “How to add shortcut-key to create a New Text File in Dolphin” askubuntu’s thread, I come with a “refined” solution show by dzon .

Check out how you can make this too.

System Setting > Workspace > Custom Shorcuts

• Rick click mouse in column empty space and choice the option > 2. New > 3. Global Shorcut > 4. Send Keyboard Input

• Go to the “Action” tab > 6. Type in this field “Menu” (without quotation marks) > 7. Select “Specific Window” in “Window” field > 8. Click in “New…” button

• Choice “Contains” option in “Window title” > 10. Type “Dolphin” (without quotation marks) in the field under > 11. Check “Normal” option in “Window Types” (click “Ok” button in the end)

• Go to the “Trigger” tab > 13. Assign that keyboard shortcut that what you want (I assigned “Shift+F10”)

After all, click “Apply” button.

(Thanks to Spectacle, it’s was easy take the screenshots and add the arrows and numbers. Such a cool software!)

This feature has been requested a bunch of times. https://bugs.kde.org/show_bug.cgi?id=260266

Unfortunately no-one has attempted to fix this yet.

Oh, it’s so cool, I’m excited when this implementation comes. For those that don’t want use my option to achieve the Context Menu, in the link send by redstrate , there is other a way to apply “Shift + F10” globally (workaround).

Adobe Community

• Global community
• 日本語コミュニティ Dedicated community for Japanese speakers
• 한국 커뮤니티 Dedicated community for Korean speakers
• Lightroom Classic
• Discussions

SDK TranslatedStrings Plugin

Copy link to clipboard

never-displayed

Microsoft Power BI Blog

Power bi november 2023 feature summary.

Welcome to the November 2023 update. We’ve got a lot of great features this month including DAX Query view, Semantic Model Scale-out, and Advanced Filtering for Paginated Reports.

There is more to explore, please continue to read on.

On-object Interaction Updates

Azure maps visual now aggregates multiple data points at the same location, datasets renamed to semantic models, edit your data model in the power bi service – updates, azure resource graph (new connector), profisee (connector update), bloomberg enterprise data and analytics (connector update), dremio (connector update), celonis (connector update).

Advanced Filtering for paginated reports

Editor’s pick of the quarter, new visuals in appsource, zebra bi tables 6.6: introducing text columns, funnel chart by powerviz, create interactive timelines with full control.

• Enhanced accessibility in paginated reports authored in Report Builder 

Skill up on Fabric with the Microsoft Learn Cloud Skills Challenge

Dynamic dataset binding for paginated reports.

Button slicer 

In this update, we are beyond excited to finally show you Power BI’s latest innovation – the Button slicer, the ultimate tool for slicing data with ease and style! This is just the first step in a thrilling 5-stage journey that will revolutionize your data exploration experience, replacing the old tile slicer with a sleek, flexible alternative that lets you customize your insights and make data-driven decisions faster than ever! Brace yourself for the November upgrade, as it redefines customization and user-friendliness.

With so many upgrades and enhancements in the new Button slicer, we continue to go beyond the improvements you saw in the new card visual, and the following list of features will have you on the edge of your seat, so let’s have a look!

• Customize the shape and appearance of your design with more control to modify the corner radius.
• With an adjustable grid layout, you can now divide your design into rows and columns , and even use pixels to customize card spacing.
• When grid layouts have more buttons than rows and columns, use overflow styles , and choose Pagination or Continuous scrolling with vertical or horizontal direction – a big step forward in design flexibility!
• Just like the new card visual, the button slicer revolutionizes alignment and format properties , and the Label feature will spotlight crucial information from within your buttons.
• Image control allows you to infuse buttons with images creating endless possibilities with URL images.
• Interactive states make your designs more engaging with options including on hover, on press, and selected to engage users with responsive interactivity!
• Get ready for the new formatting settings that will open a world of versatility and a new era of data visualization!
• Single select has been updated with a Force Selection toggle, and a new Select All option!
• The new multi-select feature is a significant step forward in user convenience and efficiency!
• A new Tooltips experience awaits you as the new button slicer now supports both default and report page tooltips to enrich your data visualization skills.

With this preview update, the new Button Slicer feature has been toggled ON by default for your convenience and is found in either the Visual gallery on the ribbon, or by selecting Build a visual after right-clicking on the canvas, and then choosing the new slicer, or lastly, by selecting new slicer from the on-object dialog . You can also toggle this feature preview ON or OFF by looking under Options > Preview features > New button slicer .

What’s next?

Remember, this was only the first stage on the new slicer roadmap. So, fasten your seatbelt, and get ready for the exciting journey ahead as our next stage unfolds and reveals even more Power BI updates, enhancements, and features! Coming next, the List and dropdown slicer!

If you’re looking to learn more about the New button slicer , watch ou t for a dedicated blog post in the coming days . If you don’t want to miss it, make sure to subscribe to the Power BI blog or follow Power BI Visuals on LinkedIn .  

Reference Labels 

Just like the Button slicer update mentioned above in this month’s Feature Summary, we’re equally excited to share Power BI’s second exhilarating advancement – Reference labels, a versatile tool for adding custom labels to new cards, providing relevant information, comparisons, key metrics, benchmarks, goals, and more, in an appealing and concise manner! As the second step in our 5-stage new card visual journey, this November upgrade will keep you smiling from ear to ear!

With Reference labels offering an abundance of creative possibilities, you and your users will be astounded by the world of wonder they unlock. Here’s an overview of the available features!

• Not only can you Reference labels to your card visual, but you even add multiple data fields to your Reference labels.
• With three main components, Title, Value, and Detail , you can also choose Custom content using a different data field or measure and apply various styles to both Title and Value.
• Extra context is available for the Detail component , showing data from a single data field well, but also customizable with styles and colors.
• With an active Divider , Reference labels have their own area where you can modify the divider line and use color to differentiate callout and reference labels.
• Reference labels can have a horizontal or vertical layout and can have custom spacing and padding.

With this preview update, the new Reference Labels feature has been toggled ON by default for your convenience and is found in either the Visual gallery on the ribbon, or by selecting Build a visual after right-clicking on the canvas, and then choosing the new slicer, or lastly, by selecting new slicer from the on-object dialog . You can also toggle this feature preview ON or OFF by looking under Options > Preview features > Reference labels .

With the first and second stage of the new Card visual now delivered, you can imagine what exciting features are waiting for you as we continue this journey together.

If you’re looking to learn more about reference labels in the new card , watch out for a dedicated blog post in the coming days. If you don’t want to miss it, make sure to subscribe to the Power BI blog or follow Power BI Visuals on LinkedIn .  

Enhance your Q&A visual with suggested synonyms from Copilot

The Q&A visual allows you to ask questions about your data and get answers in the form of visual. It provides any report viewer with an intuitive means to explore their data without requiring deeper knowledge of the model or report authoring.

Today, the Q&A visual doesn’t rely on generative AI to function. The Q&A engine processes your natural language input all inside Power BI algorithmically using a variety of linguistic principles, associating words and phrases you use with data in your model. This makes it good at answering precise questions about your data, but it may not be able to associate everything you input with data in the model. To help authors ensure that the Q&A visual provides consistent and accurate answers based on the unique language their report consumers actually use, we introduced Q&A setup tools with an emphasis on providing Q&A with synonyms for column and table names in the model. This way, authors can explicitly define different ways people might refer to their data, and users will always receive the correct answers when they ask similar questions in the future.

Power BI recognizes two types of synonyms: approved synonyms and suggestions . Approved synonyms either come directly from the names of fields themselves or are explicitly added by the author. When you uses an approved synonym in your Q&A input, it will be treated just as though you used the name of the field and the association will be presented with high confidence, signified by a solid blue underline.

Suggested terms are words Power BI thinks are likely to refer to their corresponding name. They come from a variety of sources – synonyms from the Office thesaurus show up by default, but you can also connect to your organization’s collection of approved terms and add those to your suggestions as well. Suggestions will still be used by Q&A, but with lower priority than approved synonyms, and the lower confidence will be signaled in the results with a dotted orange underline. In the Q&A setup menu, suggestions can be added to the approved synonyms list or removed entirely.

Managing synonyms is therefore an important part of improving the quality of the Q&A experience. However, coming up with synonyms for every data entity in your model can be mentally laborious and physically time-consuming. Copilot for Power BI streamlines this process by generating some for you!

If you have Copilot enabled, there are a few ways for you to get suggestions from Copilot. But first, you’ll have to enable the feature in Power BI Desktop in File > Options > Preview features > Improve Q&A with Copilot.

Then, you might be prompted to add synonyms with Copilot via a banner that shows up the first time you make a Q&A visual or open the Q&A setup menu:

You’ll also be able to get Copilot suggested synonyms via the Q&A setup menu. You can turn on Copilot as a source in the suggestion settings menu in the synonyms tab, then hit apply to get synonyms. Or, if Copilot is already enabled as a source, you can click the refresh button next to the suggestion settings dropdown.

After you’ve gotten these suggestions, you might be prompted to review them. You’ll find the new synonyms in the suggestions column in the synonyms page of the Q&A setup menu:

Copilot-suggested synonyms will function just like any other suggested synonyms. This means that they may be used by Q&A as a fallback when trying to determine what data fields a natural language input may refer to. Carefully review them in the suggestions column of the Q&A visual, remove the synonyms which are inaccurate, and approve the ones which best fit the data.

Keep in mind that as we scale out Copilot, you might run into throttling, which may cause Copilot to return incomplete results if you send too many requests in a short period of time. If that happens, you can wait a bit and try again. Copilot may also not return results for terms for which it cannot generate synonyms, or when its results are deemed inappropriate by our content filter.

Like we mentioned in our release of linguistic relationships for Q&A , we see our investment into both Copilot and the Q&A visual as mutually beneficial. There will be more features coming soon, so keep an eye out for the new ways in which we’re bringing the two together!

“Always open in new pane” setting:

Most requested, this month we are bringing you the ability to configure your pane switcher to stack panes instead of swap. If you preferred the behavior from before where panes opened side-by-side by default, you can now configure this setting by checking the new option for “ always open in new pane ” from either the Options menu or the View ribbon.

To achieve the stacked behavior of panes as before:

Turn on the new option within the Options menu:

Or, select the new option from the View ribbon:

Resizing the data flyout:

Also highly requested, this month we’ve also added the ability to resize the data flyout (second flyout) from the build button when working with long field names.

Note we have a known bug : there may be cases where the resize handles appears to the left of the data flyout if there is not enough space to expand on the right side. We’re working on a fix! As a workaround in these cases, you can move the visual to left temporarily on the canvas to resize the data flyout.

Table’s add button is back!

Table has the add button again! Originally, we had to remove the add button from the Table visual type as currently the only chart element to add from this menu was the title that does not have a default value. This added confusion to the experience because simply turning on the title did not appear to have changed anything in the visual, and users had to go to the format pane to type in their visual title. Last month we shipped placeholder text which allowed us to bring back the add button for Tables. Now, when turning on title, a placeholder will appear to type directly onto the visual.

New on-object default setup coming soon!

Each month we’ve been working toward giving users more flexibility for how they prefer to work with the PBI editor. With this month’s addition of the new “ always open in new pane ” setting, next month we’ll be able to introduce a new default setup that feels closer to the previous classic look. With this new default, we help you preset the following options with just 1 click!

• Move the “build a visual” menu to the pane switcher by default
• Show both build and data panes expanded by default
• Format pane in the pane switcher by default
• “Always open in new pane” set to ON, thereby stacking panes by default
• Collapse panes to the pane switcher instead of close “X” by default

Previously, when you had multiple data points with the same latitude and longitude field values, those points would be plotted separately, leaving them drawn one over the other at the same location. This could lead to some unclear data visualizations. For example, grouping the points by category using a legend field might leave just one category visible per location due to the overlap. This behavior was also different from visualizing those points using location names, which would aggregate the points together.

With this release, Azure Maps now aggregates points with the same latitude and longitude values in the same way that it does with location names, allowing you to see them as one bubble. These aggregated points can then be filtered or grouped as you would normally.

Narrative visual with Copilot

We’re excited to bring Copilot’s unique ability to summarize data to the rebranded Narrative with Copilot visual – formerly Smart Narratives. This visual allows you to use Copilot to summarize data across your report, or even specific pages or visuals you choose. We offer suggested prompts to get authors started, such as “Give me an executive summary,” “Answer likely questions from leadership,” and “created a bulleted list of insights.” Users can also type in their own custom prompts and questions that return summaries about their data.

Users have the ability to choose whether they want to summarize over the entire report, select pages, or even specific visuals across their report, giving them flexibility in what their summary looks like. Users will also see references for each portion of the summary that align to visuals on the various pages on the report, from which the summary lines were generated, making it easy to validate the summary’s accuracy and tie it back to the data.

The summary can be updated as the data is sliced and diced, so end users can interact with it, without editing the prompts themselves.

The narrative visual with Copilot makes it faster to communicate insights about the data that matters to you. The visual is available in the service and in Power BI Desktop.

We’re excited to share that datasets are being renamed to semantic models in Power BI and Fabric. This is necessary for disambiguation from other Fabric items and will make the product clearer and more usable. You will see this change in the most prominent UI elements in the product, and the documentation is being updated. APIs are not currently affected, and we will progressively roll out further changes. The timing of this change is driven by the upcoming general availability of Fabric and aligns with the rename for ML models. It reflects the immense progress that Power BI datasets have made in becoming an enterprise-grade semantic modeling technology. The semantic model name will help drive awareness of the unparalleled capabilities provided.

DAX query view to write and run DAX queries on your model 

Quickly explore and analyze your semantic model with DAX queries. The  DAX query view  is a fourth view in Power BI Desktop which allows you utilize the powerful DAX query language using EVALUATE to discover, analyze, and see the data in your semantic model. Similar to the Explore feature above for the Power BI service, model authors can quickly validate data and measures in their semantic model without having to build a visual, publishing, or using an additional tool. Changes made to measures can be updated back to the semantic model. DAX queries are different from DAX expressions used to create model items such as measures, calculated columns, and calculated tables, and are more like SQL queries returning data in a table.

This powerful way to interact with your data model is now available in the new  DAX query view . We give you several ways to be as productive as possible.

• Quick queries can generate DAX queries for you  in the Data pane context menu of tables, columns, or measures gives you a head start by generating a DAX query to preview data or show summary statistics. Use DAX queries to help you understand the data without creating visuals and for DirectQuery you no longer must go back to Power Query to see some sample data.
• Quick queries to get the DAX expression of all, some, or a specific measure  in a generated DAX query. It provides the DEFINE block with the measure’s DAX expression and an EVALUATE block to see the measure’s output. You can then add to the Dax query with any additional group by columns.
• Update the model  options will be available to you with any DAX query updates to measures in DAX query’s DEFINE block.
• Measures that reference other measures  can now be seen on the same screen and updated together. Preview the output of your changes then also update the model when ready.
• Report view’s   Performance Analyzer  already lets you copy the visual DAX query. Now you no longer need to take that DAX query and use another tool to view and run it – simply run it in DAX query view.
• All these features in a bigger DAX query editor similar to VS Code, including more keyboard shortcuts and the ability to  improve readability by formatting any DAX query .

We plan to continue to add functionality to the DAX query view, so your feedback will be critical. We have previously shown a vision demo with a  DAX query view copilot,  and saw the excitement for this copilot, and it will be coming soon. We also have planned investments in bringing DAX query view to live connect reports and to the Power BI service, as well as building on it to give more insight into debugging and performance of DAX. Learn more about DAX queries at  aka.ms/dax-queries  and get started today by turning on this public preview feature in  Options > Preview features .

The new data model editing in the Service feature was released to preview in April. We’ve been busy reacting to your feedback and enhancing the experience. Below are the improvements coming this month:

Mark as date table

Within the Service, you can now mark a table in your data model as a  date table . Marking a date table in your model allows you to use this table for various date-related elements including visuals, tables, quick measures, and more, with full  Time Intelligence support . To set a date table in the Service, right-click on the desired table and choose ‘Mark as date table > Mark as date table’ in the menu that appears.

Next, specify the date column by selecting it from the dropdown menu within the ‘Mark as date table’ dialog. Power BI will then perform validations on the selected column and its data to ensure it adheres to the ‘date’ data type and contains only unique values.

Rename and delete tables and columns

Within the Service the following functionality is now supported:

• Renaming and deleting any table
• Renaming and deleting any column

Please continue to submit your feedback directly in the comments of this blog post or in our feedback forum.

Data Connectivity

We are excited to announce the release of the new Azure Resource Graph connector! Please find below release notes from the Azure Resource Graph team.

Empower your data insights with our cutting-edge Power BI data connector for Azure Resource Graph! Now, seamlessly transform your Azure Resource Graph queries into stunning visualizations within Power BI. Elevate your analytics game and make data-driven decisions with ease. Unlock the synergy of Azure Resource Graph and Power BI today!

The Profisee connector has been updated. Below are update release notes from the Profisee team.

Profisee’s Power BI Connector Version 3.0 exposes new information around data quality, enhancing analytics on data quality improvements for data managed in Profisee with detailed information regarding validation issues flagged within their data. Additionally, the data types have been refined streamlining the experience for users using the Profisee Connector to load data from Profisee to Microsoft Fabric using Data Factory Gen 2 Data Flows.

The Bloomberg Enterprise Data and Analytics connector has been updated. Below are update release notes from the Bloomberg team.

This version of the Bloomberg Data and Analytics connector for Power BI includes changes to support underlying infrastructure updates and back-end performance enhancements. All user-facing features remain unchanged.

The Dremio connectors have been updated to support additional optional values and parameters.

The Celonis EMS connector has been updated with minor changes.

Within Power BI, many times users need to perform ad-hoc exploration of their data. This could be an analyst who just got access to a new dataset or data source and wants to spend time learning about the data before building a report off it. Or this could be a business user who needs to answer a specific question using the data to include in a PowerPoint presentation, but the report they’re using doesn’t answer the exact question they have. Creating a new report from scratch in these cases is a large hurdle, just to get a quick answer or screenshot for a deck.

Introducing the public preview of the new Explore feature , where users have a lightweight and focused experience to explore their data. Similar to exporting and building a PivotTable in Excel, now, directly within Power BI users can quickly launch Explore to begin creating a matrix/visual pair to get the answers they need without all the distractions and extra complexity of reports.

Simply find a dataset or report you’d like to explore:

Begin building your matrix/visual pair to get to the answers you need:

And, if you’d like to return to your work save it as an exploration:

Find more details in the Introducing Explore (Public Preview) blog post coming soon.

Copilot for Power BI in Microsoft Fabric Public Preview

We are thrilled to announce the public preview of Copilot in Microsoft Fabric, including the experience for Power BI which helps users quickly get started by helping them create reports in the Power BI web experience. We’ve also added the Copilot’s unique ability to summarize data to the Smart Narrative visual, now rebranded as the Narrative with Copilot visual. The visual is available in the Power BI service and in Power BI Desktop. Lastly in Desktop, we’ve added the ability to generate synonyms synonyms for their fields, measures, and tables using Copilot. To use Copilot you’ll need access to a workspace that has a P1 or higher or a F64 or higher capacity.

Head over to our Ignite blog Empower Power BI Users with Microsoft Fabric and Copilot to read all the announcements related to Copilot. We’ll share more details in a dedicated blog next week.

Check out the Copilot for Power BI Docs for complete instructions and requirements and don’t hesitate to leave a comment in the Fabric Community site if you have any questions.

OneLake integration for Import-mode semantic models

We are absolutely thrilled to introduce yet another groundbreaking semantic model technology to the world! We are announcing the public preview of Microsoft OneLake integration for import models. With the click of a mouse button, you can enable OneLake integration and automatically write data imported into your semantic models to delta tables in OneLake, as depicted in the following diagram. The data is instantaneously and concurrently accessible through these delta tables. Data scientists, DBAs, app developers, data engineers, citizen developers and any other type of data consumer can now get seamless access to the same data that drives your business intelligence and financial reports. You can include these delta tables in your Lakehouses and Synapse Data Warehouses via shortcuts so that your users can use T-SQL, Python, Scala, PySpark, Spark SQL, R, and no-code/low-code solutions to query the data.

OneLake integration can even help you if you don’t plan to query the data. Perhaps you only want to export the data to backup files. Thanks to OneLake integration, this is very straightforward now. Ensure that your import-mode semantic model is hosted in a workspace on a Premium or Fabric capacity and that the large dataset storage format is enabled. Then, enable OneLake integration and perform a manual or scheduled data refresh operation. That’s it! The semantic model writes the imported data to the delta tables as part of the refresh operation. Exporting import-mode tables has never been easier. The delta tables are kept up to date without requiring any ETL pipelines copying data.

Of course, you can also export the data programmatically via Tabular Object Model (TOM) and Tabular Model Scripting Language (TMSL) if you can access your semantic model through XMLA in read-write mode. For example, you can open SQL Server Management Studio (SSMS) and run the following TMSL command (see also the screenshot below):

If you have installed the latest version of  OneLake File Explorer , you can conveniently verify the success of the export process by using Windows File Explorer. In OneLake File Explorer, right click on the workspace folder and select Sync from OneLake. Then, in the workspace folder, look for a subfolder with a name that matches your semantic model and that ends with .SemanticModel, as in the screenshot above. In this semantic model folder, every import-mode table has a subfolder that contains the delta table’s parquet files and delta log.

But you don’t need to know these file system details if you add shortcuts for your semantic model’s delta tables to other workloads in Fabric, such as lakehouses etc. Simply launch the Shortcut Wizard UI, pick Microsoft OneLake, select the semantic model, and then pick the tables you want to include, as in the screenshots below, and that’s it. You are ready to read and query the tables using your favorite data tools and APIs.

And there you have it! Now you can use Direct Lake mode to read delta tables directly from OneLake and write delta tables thanks to OneLake integration. Fabric is redefining how customers can build their BI solutions for faster performance at big-data scale while at the same time reducing Total Cost of Ownership (TCO) and infrastructure complexity. For example, you no longer need an entire portfolio of homegrown ETL solutions to get data volumes of any size in and out of semantic models. So, don’t delay and see for yourself how OneLake integration can help you maximize the return of your investments into semantic models by making the data instantaneously and concurrently accessible to data scientists, DBAs, app developers, data engineers, citizen developers and any other type of data consumer you may have in our organizations through delta tables added to your Lakehouses and Synapse Data Warehouses via shortcuts. And as always, provide us with feedback if you want to help deliver additional enhancements. We hope you are as excited about  OneLake  integration as we are. We think this is a massive innovation and are looking forward to hearing from you!

RLS/OLS security and stored credentials for Direct Lake semantic models

We are thrilled to announce the public preview of RLS/OLS security and stored credentials for Direct Lake semantic models. RLS/OLS security is a Power BI feature that enables you to define row-level and object-level access rules in a semantic model, so that different users can see different subsets of the data based on their roles and permissions. Stored credentials help reduce configuration complexity and are strongly recommended when using RLS/OLS with Direct Lake semantic models. The following screenshot shows how you can add users to RLS roles in a Direct Lake model by using the Web modeling experience. The web modeling security roles dialog will be fully deployed in the coming days or weeks. For more information about how to set up stored credentials, see the Direct Lake product documentation. For RLS and OLS, see the articles Row-level security (RLS) with Power BI and Object level security (OLS) .

There is (almost) nothing special for RLS/OLS in Direct Lake models. You can define roles and assign users as for any other semantic model type. But keep in mind that by default Direct Lake models use single sign-on (SSO) authentication to the underlying data source. Using RLS/OLS in conjunction with SSO can be challenging because it involves multiple authorization layers—RLS/OLS in the semantic model and user authorization at the data source. For example, if you wanted to authorize a new user, you would have to add that new user to appropriate RLS roles and ensure that the user has access permissions to the underlying delta tables in the lakehouse or data warehouse.

Managing user authorization at multiple layers adds complexity and friction. That’s why we are excited to introduce support for stored credentials with Direct Lake semantic models. Your semantic models can now access the delta tables at the source with a single, fixed identity on behalf of the users instead of delegating the actual user identities via SSO. When adding new users to an RLS role, you are effectively authorizing them to use the fixed identity. Because this approach avoids SSO-related complexity and friction, we strongly recommend that you switch to a fixed identity whenever you add RLS/OLS to a Direct Lake model. Switching to a fixed identity is as easy as binding the Direct Lake model to a Shareable Cloud Connection (SCC) that has SSO disabled. For more information, see Connect to cloud data sources in the Power BI service in the product documentation.

Here are the steps to configure a Direct Lake model with a fixed identity:

• Display the settings of the Direct Lake model and expand the Gateway and cloud connections section. Note that your Direct Lake model has a SQL Server data source pointing to a lakehouse or data warehouse in Fabric.
• Under Maps to, open the listbox, and click on Create a connection. This will pull you to the connections management page with the new connection form opened and prepopulated with the data source information.
• Select OAuth 2.0 or Service Principal as the authentication method and provide the credentials of the fixed identity you want to use.
• Make sure you disable to checkbox labeled Use SSO via Azure AD for DirectQuery queries, as in the following screenshot.
• Configure any other parameters as needed and then click Create. This pulls you back to the Direct Lake model settings page. Verify that the data source is now associated with the non-SSO cloud connection.

The ability to set up stored credentials is available today! The RLS editor for Direct Lake datasets in the web modeling experience is being deployed and will be visible in the coming days or weeks.

And that’s it for this announcement of RLS/OLS with fixed identities for Direct Lake semantic models. For more information see the articles about Direct Lake semantic models in the product documentation. We hope that these exciting new capabilities enable you to create and migrate even more Power BI semantic models to Direct Lake mode so that you can take full advantage of all the data movement, data science, real-time analytics, and Office integration, and AI, and BI capabilities that Fabric and Power BI have to offer. And please provide us with feedback if you want to help shape the future on world’s best and most successful BI service – Power BI on the unified Fabric platform! We always love to hear from you!

Learn about Direct Lake in Power BI and Microsoft Fabric – Power BI | Microsoft Learn

Sharable cloud connections for semantic models

Along with the general availability (GA) of shareable cloud connections (SCC), we are happy to announce that SCC support for semantic models and paginated reports is GA as well. Now, you can use this modern connection type in conjunction with your production semantic models and paginated reports to access cloud data sources and centralize cloud connection management. In enterprise organizations, centralizing cloud connection management in addition to data gateway management can help to lower the overhead of maintaining data connections and credentials. SCCs let you securely share access to cloud data sources through an access-control list. The credentials are protected and cannot be retrieved from the SCCs, but Power BI users with at least Use permissions can connect their semantic models and paginated reports to the cloud data sources through these SCCs. You can also create multiple connections to the same data source, which is particularly useful if you want to use different connection settings, such as different credentials, privacy settings, or single-sign-on settings, for different semantic models, paginated reports, and other artifacts.

Semantic model scale-out  

We are thrilled to announce semantic model scale-out is now generally available (GA). Large-scale production solutions will benefit from high user concurrency, as Power BI automatically scales out read-only replicas to ensure performance doesn’t slow down when lots of users are using the system at the same time. And of course, automatic scale out works for Direct Lake semantic models! Additionally, Import-mode semantic models will benefit from refresh isolation, ensuring business users are unaffected by resource-intensive refresh operations, and continue to enjoy enable blazing-fast queries for interactive analysis.

Here’s a quick summary of the benefits semantic model scale-out can provide to your reports, dashboards, and other BI solutions:

• Increased query throughput    Power BI can automatically scale read-only replicas when query volume increases and fluctuates.
• Refresh isolation    Refresh and write operations on the read-write replica do not impact the query performance on read-only replicas.
• More flexibility for advanced data refresh scenarios    As a side-benefit of refresh isolation, you can now perform advanced refresh operations on the read-write replica without impacting the read-only replicas. Simply disable automatic replica synchronization, then refresh, refresh, refresh until the read-write replica is fully updated, and then synchronize the read-replicas manually.

Semantic-model scale-out is the last of the key features to make Microsoft Fabric and Power BI a superset of Azure Analysis Services (AAS) and is superior in Fabric compared to its equivalent in AAS. Unlike AAS, scale out takes place based on live user demand, and adjusts automatically to changes in usage patterns. AAS, on the other hand, requires detailed analysis to determine peak usage times, creation of automation scripts, and ongoing monitoring to ensure optimum set up. Additionally, cost in AAS increases linearly per replica, unlike Fabric that is usage based.

Please refer to the Configure dataset scale-out article in the product documentation for details on how to enable semantic model scale-out.

Show visuals as tables

Leveraging our previous accessibility improvements to table and matrix, we are now introducing a new view mode called Show visuals as tables which displays report visuals in a tabular format with a single action. Some users may prefer to consume data in a text-based or tabular format depending on their different learning styles and usage of assistive technologies. This provides a supplemental format for visuals that allows users to display the data in the way that best meets their needs.

This new view mode is similar to how Show as a table displays underlying data for individual visuals today. Show visuals as tables will display the underlying data for visuals for all pages in the current report, with the added functionality of interaction and cross-filtering capabilities.

To activate this view mode, navigate to the view dropdown menu and select Show visuals as tables.

To revert, select Show original visuals.

Or simply use the keyboard shortcut Control + Shift + F11 to toggle between the two views.

Learn more details about this feature, including limitations, in our documentation: Consuming reports in Power BI with accessibility tools

You can now use “Advanced Filtering” while authoring paginated reports on the service. This allows you to define conditions such as contains or does not contain, is not equal or is equal, a specific value. You can learn more about creating paginated reports with filters on the service here .

Visualizations

• Performance Flow – xViz
• Galigeo For Power BI
• Calendar by Datanau
• Image Pro by CloudScope
• Sparkline by OKViz
• Apex Gantt Chart

With Zebra BI Tables 6.6 , you can add multiple text columns inside the table. Using this feature, you can bridge the gap in data visualization by having relevant information side by side in the world’s best table/matrix custom visual for Power BI.

Watch the video of the new functionality !

With this feature , you can now display multiple text columns in a tabular way , which leads to a better understanding of the data when displaying more attributes of the same Category. Additionally, there is no need to apply any complex DAX functions . Simply add additional text columns into the ‘Values’ placeholder.

SOME POPULAR USE CASES:

In one-to-one mapping , you usually need to add additional information next to the descriptive column to ensure data accuracy, consistency, and ease of reference.

• Product ID: Product name
• Product ID: SKU: Shipping/Order ID
• Job ID: Job title

The new feature also works in cases with one-to-many mapping . For example,

• Customer: Sales representatives because the same person can represent multiple customers.

You can also add multiple text columns when presenting data in a hierarchical table or using cross-tables for quarterly performance.

Try it on your data today for free .

The Funnel Chart by Powerviz is a stunning and informative visualization. It has 4 chart types in 1 visual, including a pyramid chart. The Power BI-certified visual is useful for tracking progress through different stages. It can also group data with legends for detailed insights.

Key Features:

• Funnel Settings : Multiple display types are available, including vertical and horizontal orientation.
• Data Colors : Offers 7 schemes and 30+ color palettes.
• Labels : Select from multiple display styles with a custom label option included.
• Conversion Rate : In a single click measure the percentage of top and bottom stages to identify bottlenecks.
• Fill Patterns : Highlight stages with custom or pre-filled patterns.
• Conditional Formatting  – Create rules based on measure or category rules.

Many other features included are ranking, annotation, grid view, show condition, and accessibility support.

Business Use Cases:

• Sales Funnel Analysis : Track sales stages.
• Marketing Campaigns : Assess lead generation and conversion rates.
• User Onboarding : Monitor steps to product adoption.
• Website Traffic : Visualize visitor drop-offs.

Try Funnel Chart for FREE from  AppSource .

Check out the visual features in the demo file .

Step by Step instructions and documentation.

To learn more, visit the Powerviz website.

Funnel Chart by Powerviz Feature Video  on YouTube.

Drill Down Timeline PRO lets you easily create timelines with a date/time hierarchy. Click directly on the chart to drill down to examine specific periods in detail. Combine multiple series and choose between multiple chart types (line, column, area). Learn more.

Main features include:

• On-chart interactions – click on chart to drill down to months, days, hours, or milliseconds
• Customize up to 25 series
• DAX measure support
• Take customization to the next level with conditional formatting
• Use series defaults and value labels defaults to customize multiple series
• Static and dynamic thresholds – set up to 4 thresholds to demonstrate targets
• Full customization – colors, gradients, backgrounds, fonts, and more
• Touch device friendly – explore data on any device

Popular use cases:

• Banking & Finance – stock exchange indices, capital ratios, transaction volumes
• Sales & Marketing – web traffic, audience reach, sales revenue
• Information Technologies – network traffic, response times, syslog and error trends
• Manufacturing – quality metrics, uptime and downtime, production output and cost

Get Drill Down Timeline PRO from AppSource!

ZoomCharts Drill Down Visuals are known for their interactive drilldowns, smooth animations, rich customization options and support: interactions, selections, custom and native tooltips, filtering, bookmarks, and context menu.

Enhanced accessibility in paginated reports authored in Report Builder

The StructureTypeOverwrite property has been added to the .rdl model. You can use it to improve accessibility for paginated reports in Microsoft Report Builder and Power BI Report Builder. You can then publish these reports to the PBI service. Read more about improving accessibility of paginated report .

We are excited to announce the Microsoft Ignite: Microsoft Fabric Challenge as part of the Microsoft Learn Cloud Skills Challenge . Skill up for in-demand tech scenarios and enter to win a VIP pass to the next Microsoft Ignite. The challenge is on until January 15, 2024.

In this challenge, you will learn how to connect to data, ingest it with Data Factory and notebooks, store it in the lakehouse or data warehouse, and create Power BI reports to turn your data into competitive advantage.

The challenge will help you prepare for the Microsoft Certified: Fabric Analytics Engineer Associate certification and new Microsoft Applied Skills credentials covering the lakehouse and data warehouse scenarios, which are coming in the next months.

Use dynamic binding to maintain a single template of an RDL report that can be connected to multiple datasets across workspaces, instead of copying and maintaining hundreds of report duplicates. You don’t need to create copies of the same report with a different dataset. You can bind datasets dynamically to a paginated report as outlined in the “Bind datasets dynamically to a paginated report” documentation .

You can also bind datasets dynamically to a paginated report visual as outlined in the “Bind datasets dynamically to a paginated report visual” documentation .

That is all for this month! Please continue sending us your feedback and do not forget to vote for other features that you would like to see in Power BI! We hope that you enjoy the update! If you installed Power BI Desktop from the Microsoft Store,  please leave us a review .

Also, don’t forget to vote on your favorite feature this month on our community website. 

As always, keep voting on  Ideas  to help us determine what to build next. We are looking forward to hearing from you!

• Azure Resource Graph
• Microsoft Fabric

Sign up for the Power BI Newsletter

Sign up below to get the latest from Power BI, direct to your inbox!

I would like to receive the Power BI newsletter. Privacy Statement.

Participation requires transferring your personal data to other countries in which Microsoft operates, including the United States. By submitting this form, you agree to the transfer of your data outside of China. Privacy Statement .