Conditional formatting for Sub-Groups in Power BI using DAX | Querinfer
Автор: Querinfer
Загружено: 2021-02-09
Просмотров: 2266
You may need to present data in PowerBI Matrix table and highlight the maximum or minimum values. With normal conditional formatting this is not possible. Learn to use DAX formulas RANKX and SWITCH for amazing dashboard effects and decision making.
You just need to have PowerBI desktop and excel file which can be downloaded from the link given below:
https://drive.google.com/file/d/1_n2K...
Time stamps
Intro 00:00
Download material 01:13
Import data in PowerBI 02:45
Simple conditional formatting 05:05
Matrix Table 06:48
Simple Ranking using formula RANKX 07:35
Filtered Ranking for subgroups RANKX 08:51
define colour with formula SWITCH 10:47
Field based conditional formatting 12:44
Double sub groups for ranking RANKX 15:05
End message 18:08
You can also go to my facebook page and check latest happenings in SHKExcelWorld:
https://www.youtube.com/shkexcelworld...
/ shkexcelworld
/ shkexcelworld
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
