Introducing EXPAND and COLLAPSE for visual calculations in Power BI

preview_player
Показать описание
Introduction to the two basic visual context navigation functions in DAX: EXPAND and COLLAPSE. There functions are used in Power BI visual calculations.


  1. SQLBI
Рекомендации по теме
Introducing EXPAND and 0:19:52

Introducing EXPAND and COLLAPSE for visual calculations in Power BI

Word: Collapse & 0:02:04

Word: Collapse & Expand Headings by Chris Menard

Word 2016 - 0:02:39

Word 2016 - Expand & Collapse Text - How To Minimize and Maximize Sections, Body, & Headings...

Expand and Collapse 0:01:03

Expand and Collapse Functions | Learn How To Use Workflowy

About Expand/Collapse Sections 0:01:01

About Expand/Collapse Sections in Microsoft Word

How to expand 0:00:54

How to expand and collapse paragraphs

Expand and Collapse 0:04:53

Expand and Collapse Details in an Excel Pivot Table

How to Expand 0:06:29

How to Expand And Collapse Floating Button in Android Studio | ExpandFloatingButton | Android Coding

Expand and Collapse 0:00:22

Expand and Collapse Panels in Photoshop

Expand/Collapse Portals in 0:14:59

Expand/Collapse Portals in FileMaker

How to implement 0:03:05

How to implement 'expand and collapse' in Cognos Workspace (swedish)

VS Code tips 0:00:48

VS Code tips — Collapse/expand search results

Group Rows and 0:09:35

Group Rows and Columns in Excel With Expand & Collapse Buttons | Include Summary and Subtotals

Expand and collapse 0:02:11

Expand and collapse rows in Power BI | Matrix Tables

How to create 0:01:48

How to create and use container shapes in draw.io to collapse and expand content

Flutter Tutorial - 0:05:22

Flutter Tutorial - How To Expand/Collapse Widget | Expandable Panel

Number of children 0:00:19

Number of children in expand/collapse button

Expand and Collapse 0:00:20

Expand and Collapse the Calendar

How to Collapse 0:00:53

How to Collapse Rows in Smartsheet (Expand/Collapse Rows in Smartsheet)

Dynamic Expand Collapse 0:03:32

Dynamic Expand Collapse Messages in Excel - Monkey Shorts Episode 020

MS Word Tips 0:03:10

MS Word Tips 1: Collapse or expand parts of a document through Headings

Collapse/Expand details in 0:05:10

Collapse/Expand details in HTML.

How to Create 0:01:54

How to Create Scroll Effects with Expand/Collapse Feature in Figma

003 Expand And 0:02:49

003 Expand And collapse the ribbon - Microsoft Excel

Комментарии
Автор

This is fantastic. It's been a huge shortcoming of Power BI that you cannot make calculations from the intuition of the matrix visual. It's a huge pain, even for an experienced developer, let alone for a user/beginner, to first translate your intuition to the filter context before writing the code. This finally solves that issue!

It's one step closer to the flexibility that eg Business Objects offers, but in this case with more elegance and functionality. Power BI is slowly (finally) turning into a tool I can be proud to use.

eriksnijders
Автор

This is probably a good way to provide end users with a way to change the operators used in a visual. Quite useful as well if you are performing calculations on top of already complex measures that only need to be recalculated on the context of an specific visual. Awesome video as usual! Thank you Alberto!

yeyoremix
Автор

What is that lattice ? any tool to auto-generate them ?

decode-biz
Автор

Q: What could be the reason that SSAS-onPremise isn't supported? Is VisualCalculation executed by FE or something on top of FE?

olbu