Blog Stats
- 2,853,280 hits
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- How to sort bar chart in descending order?
- Show number in thousand (k) or in million (M) by using custom format
- How to replace value with a value from another column in Power Query
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Rename column names in a dynamic way with #Excel #PowerQuery
- Perform VLOOKUP with 2 lookup values
- Insert a text string into a specific position of another text string in #Excel
- Be cautious when using XLOOKUP
- Open an embedded Excel file during a slide show in PowerPoint?
My YouTube Channel
My Facebook page
- My Tweets
Category Archives: Power BI Desktop
The Power BI Journey
Note: This is not a “how-to” post. In this article, I share my thoughts on how people start their Power BI journey, based on my observation and imagination. 😁 When you say you want to learn Power BI, what do … Continue reading
Quick tip – Zoom in and out of the #PowerQuery editor
In both #Excel and #PowerBI Did you know… we can ZOOM IN or zoom out everything but ribbon in the Power Query Editor in both Excel and Power BI Desktop… … by pressing CTRL+SHIFT+= CTRL+SHIFT+- respectively. The story behind the … Continue reading
Insert blank columns to table in #PowerBI Desktop
In Excel, it is a common (but not necessarily a good) practice for people to add a thin blank column in a table to give a visual effect of divider. Like the screenshot below: To insert a blank column in … Continue reading