登录查看更多内容

Power BI Hidden Gems Part 2

Wyn Hopkins

Leading a team that solves data challenges for companies and people Power BI | Excel | Fabric | Solver Budgeting & Consolidation. Control costs, reduce risk and assist growth Microsoft MVP ??5 Million+ YouTube views

发布日期: 2021年12月16日

+ 关注

This is my second set of Power BI quick tips and tricks

A few quick tips including:

Power Query:

Ctrl SHIFT plus to zoom

Holding Ctrl and SHIFT to change data types on multiple columns

Power BI:

Multi Column Sort in Power BI Table Visual

Slicer Slider to lines rather than circles

Format numbers as Millions using #,#0,,.0; (#,#0,,.0);-

Drag a page quickly to the beginning

Also check out my previous tips article and video:

https://www.dhirubhai.net/pulse/did-you-know-hidden-power-bi-features-wyn-hopkins/

Wyn

要查看或添加评论，请登录

The Best Dependent Drop Down Technique

2024年11月15日
Should you use Measures for Conditional Formatting?

2024年6月9日
Consolidate and Hyperlink to Excel files on SharePoint

2024年1月3日
The greatest multi-level Excel drop-down list ever!

2023年11月3日
Default Your Slicer to the Current Month in Power BI

2023年7月31日
Power BI Licensing Explained

2023年5月27日
Power BI May 2023 Release

2023年5月26日
Simpler DAX ? = Power Query

2023年5月12日
Power BI Explained

2023年3月29日
SUMX explained.

2023年2月27日

查看全部

社区洞察

Community Organizing

How do you adjust your power analysis in changing conditions?
Database Queries

How do you use the IF, AND, OR, and NOT functions to create conditional logic and criteria in Excel?
Office Administration

How can you use VLOOKUP to match data in Excel?
Task Management

What are the best formulas or functions to calculate task progress and completion rate in Excel?
Business Intelligence

What are the most effective ways to make a lasting impression on your business intelligence network?
Statistics

What are the most effective ways to create pie charts in Excel?
Business Intelligence

What do you do if your peers are outshining you in Business Intelligence (BI)?
Consulting

How can you use the SUMIF function in Excel to analyze data?
Business Intelligence

How do you use VLOOKUP for efficient data searching in Excel?
Presentations

How can you use heat maps to present data in a way that is both informative and visually appealing?

其他会员也浏览了

Mastering Power BI: Keeping Your Card Visuals Static When Applying Filters.

Stephen Sila 3 个月
Power BI Quick Tips are Back

Arno Wakfer MCT 1 年
What is Power BI?

Wyn Hopkins 3 年
Now You See Me! Use cases of ALL DAX Function in Power BI

Reza Rad 5 年
What are the Use Cases of Dataflow for You in Power BI?

Reza Rad 5 年
Conditional Column in Power BI using Power Query; You can do anything!

Reza Rad 5 年
Date Table for Power BI and Excel

Wyn Hopkins 3 年
What Fields to Hide in Your Power BI Solution?

Reza Rad 5 年
Remove Duplicate Doesn’t Work in Power Query for Power BI? Here is the Solution!

Reza Rad 5 年
Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in a Table Section 1

Reza Rad 5 年

Power Query:

Power BI:

The Best Dependent Drop Down Technique

2024年11月15日

Should you use Measures for Conditional Formatting?

2024年6月9日

Consolidate and Hyperlink to Excel files on SharePoint

2024年1月3日

The greatest multi-level Excel drop-down list ever!

2023年11月3日

Default Your Slicer to the Current Month in Power BI

2023年7月31日

Power BI Licensing Explained

2023年5月27日

Power BI May 2023 Release

2023年5月26日

Simpler DAX ? = Power Query

2023年5月12日

Power BI Explained

2023年3月29日

SUMX explained.

2023年2月27日

社区洞察

其他会员也浏览了

Mastering Power BI: Keeping Your Card Visuals Static When Applying Filters.

Power BI Quick Tips are Back

What is Power BI?

Now You See Me! Use cases of ALL DAX Function in Power BI

What are the Use Cases of Dataflow for You in Power BI?

Conditional Column in Power BI using Power Query; You can do anything!

Date Table for Power BI and Excel

What Fields to Hide in Your Power BI Solution?

Remove Duplicate Doesn’t Work in Power Query for Power BI? Here is the Solution!

Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in a Table Section 1