DAX - Using SWITCH() to change the background colour in a Power BI table
25.1 هزار بار بازدید -
2 سال پیش
-
Power BI - Using the
Power BI - Using the DAX SWITCH() function to change the background colour of a cell in a Power BI table. In this video I provide an example of the cell colour changing based upon the number of dates to a project deadline.
In Power BI DAX SWITCH() works a bit like a multiple-choice question. The SWITCH statement is given a value (here, the number of days to the deadline) and it gives you back a result (here, the cell colour).
This example provides a basic template of a SWITCH function which a user can expand upon for more complex conditions than that shown.
Timings:
00:00 - 01:10 Introduction
01:10 - 02:30 Create Measure to calculated number of days to deadline
02:30 - 05:40 Create Measure with SWITCH() statement to change cell colours
05:40 - 07:30 Recap steps taken and talk through example
07:30 - 08:30 Apply Measure containing SWITCH to cells of table.
#powerbi #powerbicolours #DAXSWITCH #SWITCH() #SWITCHfunction #powerbitutorial #dax #ChangeCellColour #changebackgroundcolor
In Power BI DAX SWITCH() works a bit like a multiple-choice question. The SWITCH statement is given a value (here, the number of days to the deadline) and it gives you back a result (here, the cell colour).
This example provides a basic template of a SWITCH function which a user can expand upon for more complex conditions than that shown.
Timings:
00:00 - 01:10 Introduction
01:10 - 02:30 Create Measure to calculated number of days to deadline
02:30 - 05:40 Create Measure with SWITCH() statement to change cell colours
05:40 - 07:30 Recap steps taken and talk through example
07:30 - 08:30 Apply Measure containing SWITCH to cells of table.
#powerbi #powerbicolours #DAXSWITCH #SWITCH() #SWITCHfunction #powerbitutorial #dax #ChangeCellColour #changebackgroundcolor
2 سال پیش
در تاریخ 1400/12/16 منتشر شده
است.
25,119
بـار بازدید شده