⚡⚡⚡ The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. [ Ссылка ]



00:00 Intro
00:30 the Files and playing along
01:44 importing the data and discuss the Calendar and Time Tables
05:25 The New Slicer
07:58 The New Card
12:12 The DAX formula for the up down arrow
12:49 Conditional formatting on the up down arrow
14:20 The Line Chart features

The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. [ Ссылка ]

🔗Links
🔗 Online Version to play with: [ Ссылка ]

🔗Download a starting point file and the data: [ Ссылка ]

🔗Access Analytic Template files: [ Ссылка ]


🔗UNICHAR Codes: [ Ссылка ]

🔗The Conditional Formatting Video: [ Ссылка ]


The DAX for the indicator
!!Note I can't use angled brackets here so I've used emoji instead

Usage PY Variance Indicator =
//For use in Card Visual Details section
VAR _Variance = [Usage v Prior Year]
VAR _Result =
SWITCH(
TRUE(),
_Variance◀️0, UNICHAR(129055),
_Variance=0, UNICHAR(129112),
_Variance▶️0, UNICHAR(129053)
)
RETURN
_Result



Did you know I've written a book "Power BI for the Excel Analyst"?
[ Ссылка ]


Connect with me
[ Ссылка ]

свернуть